diff --git a/hmda-dump.sql b/hmda-dump.sql new file mode 100644 index 0000000000000000000000000000000000000000..048775542f4946637861dd2b5d5c70dddc93eb9b --- /dev/null +++ b/hmda-dump.sql @@ -0,0 +1,35 @@ +COPY SELECT * FROM hmda_06 SAMPLE 10000 INTO '/scratch/hannes/hmda/hmda_06_1.csv'; +COPY SELECT * FROM hmda_06 SAMPLE 100000 INTO '/scratch/hannes/hmda/hmda_06_2.csv'; +COPY SELECT * FROM hmda_06 SAMPLE 1000000 INTO '/scratch/hannes/hmda/hmda_06_3.csv'; +COPY SELECT * FROM hmda_06 SAMPLE 10000000 INTO '/scratch/hannes/hmda/hmda_06_4.csv'; +COPY SELECT * FROM hmda_06 INTO '/scratch/hannes/hmda/hmda_06_f.csv'; + +COPY SELECT * FROM hmda_07 SAMPLE 10000 INTO '/scratch/hannes/hmda/hmda_07_1.csv'; +COPY SELECT * FROM hmda_07 SAMPLE 100000 INTO '/scratch/hannes/hmda/hmda_07_2.csv'; +COPY SELECT * FROM hmda_07 SAMPLE 1000000 INTO '/scratch/hannes/hmda/hmda_07_3.csv'; +COPY SELECT * FROM hmda_07 SAMPLE 10000000 INTO '/scratch/hannes/hmda/hmda_07_4.csv'; +COPY SELECT * FROM hmda_07 INTO '/scratch/hannes/hmda/hmda_07_f.csv'; + +COPY SELECT * FROM hmda_08 SAMPLE 10000 INTO '/scratch/hannes/hmda/hmda_08_1.csv'; +COPY SELECT * FROM hmda_08 SAMPLE 100000 INTO '/scratch/hannes/hmda/hmda_08_2.csv'; +COPY SELECT * FROM hmda_08 SAMPLE 1000000 INTO '/scratch/hannes/hmda/hmda_08_3.csv'; +COPY SELECT * FROM hmda_08 SAMPLE 10000000 INTO '/scratch/hannes/hmda/hmda_08_4.csv'; +COPY SELECT * FROM hmda_08 INTO '/scratch/hannes/hmda/hmda_08_f.csv'; + +COPY SELECT * FROM hmda_09 SAMPLE 10000 INTO '/scratch/hannes/hmda/hmda_09_1.csv'; +COPY SELECT * FROM hmda_09 SAMPLE 100000 INTO '/scratch/hannes/hmda/hmda_09_2.csv'; +COPY SELECT * FROM hmda_09 SAMPLE 1000000 INTO '/scratch/hannes/hmda/hmda_09_3.csv'; +COPY SELECT * FROM hmda_09 SAMPLE 10000000 INTO '/scratch/hannes/hmda/hmda_09_4.csv'; +COPY SELECT * FROM hmda_09 INTO '/scratch/hannes/hmda/hmda_09_f.csv'; + +COPY SELECT * FROM hmda_10 SAMPLE 10000 INTO '/scratch/hannes/hmda/hmda_10_1.csv'; +COPY SELECT * FROM hmda_10 SAMPLE 100000 INTO '/scratch/hannes/hmda/hmda_10_2.csv'; +COPY SELECT * FROM hmda_10 SAMPLE 1000000 INTO '/scratch/hannes/hmda/hmda_10_3.csv'; +COPY SELECT * FROM hmda_10 SAMPLE 10000000 INTO '/scratch/hannes/hmda/hmda_10_4.csv'; +COPY SELECT * FROM hmda_10 INTO '/scratch/hannes/hmda/hmda_10_f.csv'; + +COPY SELECT * FROM hmda_11 SAMPLE 10000 INTO '/scratch/hannes/hmda/hmda_11_1.csv'; +COPY SELECT * FROM hmda_11 SAMPLE 100000 INTO '/scratch/hannes/hmda/hmda_11_2.csv'; +COPY SELECT * FROM hmda_11 SAMPLE 1000000 INTO '/scratch/hannes/hmda/hmda_11_3.csv'; +COPY SELECT * FROM hmda_11 SAMPLE 10000000 INTO '/scratch/hannes/hmda/hmda_11_4.csv'; +COPY SELECT * FROM hmda_11 INTO '/scratch/hannes/hmda/hmda_11_f.csv';