Information about the data made available by the California Secretary of State about campaign finances and lobbying in the state. Not the data itself, just info about it.
load data local infile '/tmp/cvr_campaign_disclosure_cd.tsv' into table cvr_campaign_disclosure_cd fields terminated by '\t' lines terminated by '\r\n' ignore 1 lines
Query OK, 276830 rows affected, 5 warnings (30.43 sec)
Records: 276830 Deleted: 0 Skipped: 0 Warnings: 5
| Level | Code | Message
| Warning | 1262 | Row 340 was truncated; it contained more data... |
| Warning | 1262 | Row 471 was truncated; it contained more data... |
| Warning | 1262 | Row 731 was truncated; it contained more data... |
| Warning | 1262 | Row 109223 was truncated; it contained more data... |
| Warning | 1262 | Row 155368 was truncated; it contained more data... |
5 rows in set (0.00 sec)
load data local infile '/tmp/lpay_cd.tsv' into table lpay_cd fields terminated by '\t' lines terminated by '\r\n' ignore 1 lines
| Warning | 1262 | Row 8215 was truncated; it contained more data... |
| Warning | 1262 | Row 9686 was truncated; it contained more data... |
| Warning | 1262 | Row 13500 was truncated; it contained more data... |
| Warning | 1262 | Row 13662 was truncated; it contained more data... |
| Warning | 1262 | Row 13743 was truncated; it contained more data... |
| Warning | 1262 | Row 15363 was truncated; it contained more data... |
| Warning | 1262 | Row 15368 was truncated; it contained more data... |
| Warning | 1262 | Row 15396 was truncated; it contained more data... |
| Warning | 1262 | Row 15401 was truncated; it contained more data... |
| Warning | 1262 | Row 16530 was truncated; it contained more data... |
| Warning | 1262 | Row 16894 was truncated; it contained more data... |
| Warning | 1262 | Row 17583 was truncated; it contained more data... |
| Warning | 1262 | Row 18868 was truncated; it contained more data... |
| Warning | 1262 | Row 18874 was truncated; it contained more data... |
| Warning | 1262 | Row 19933 was truncated; it contained more data... |
| Warning | 1262 | Row 24872 was truncated; it contained more data... |
| Warning | 1262 | Row 29861 was truncated; it contained more data... |
| Warning | 1262 | Row 30326 was truncated; it contained more data... |
| Warning | 1262 | Row 30400 was truncated; it contained more data... |
| Warning | 1262 | Row 33059 was truncated; it contained more data... |
| Warning | 1262 | Row 39763 was truncated; it contained more data... |
| Warning | 1262 | Row 40879 was truncated; it contained more data... |
| Warning | 1262 | Row 42010 was truncated; it contained more data... |
| Warning | 1262 | Row 42135 was truncated; it contained more data... |
| Warning | 1262 | Row 42140 was truncated; it contained more data... |
| Warning | 1262 | Row 42154 was truncated; it contained more data... |
| Warning | 1262 | Row 42300 was truncated; it contained more data... |
| Warning | 1262 | Row 42780 was truncated; it contained more data... |
| Warning | 1262 | Row 45979 was truncated; it contained more data... |
| Warning | 1262 | Row 50057 was truncated; it contained more data... |
| Warning | 1262 | Row 142404 was truncated; it contained more data... |
| Warning | 1262 | Row 154077 was truncated; it contained more data... |
| Warning | 1262 | Row 154078 was truncated; it contained more data... |
| Warning | 1262 | Row 154086 was truncated; it contained more data... |
| Warning | 1262 | Row 155117 was truncated; it contained more data... |
| Warning | 1262 | Row 180452 was truncated; it contained more data... |
| Warning | 1262 | Row 180453 was truncated; it contained more data... |
| Warning | 1262 | Row 180585 was truncated; it contained more data... |
| Warning | 1262 | Row 184580 was truncated; it contained more data... |
| Warning | 1262 | Row 184581 was truncated; it contained more data... |
| Warning | 1262 | Row 185044 was truncated; it contained more data... |
| Warning | 1262 | Row 243486 was truncated; it contained more data... |
| Warning | 1262 | Row 250898 was truncated; it contained more data... |
| Warning | 1262 | Row 263320 was truncated; it contained more data... |
| Warning | 1262 | Row 264900 was truncated; it contained more data... |
| Warning | 1262 | Row 266156 was truncated; it contained more data... |
| Warning | 1262 | Row 323757 was truncated; it contained more data... |
47 rows in set (0.00 sec)
load data local infile '/tmp/rcpt_cd.tsv' into table rcpt_cd fields terminated by '\t' lines terminated by '\r\n' ignore 1 lines
| Warning | 1262 | Row 1075882 was truncated; it contained more data... |
| Warning | 1261 | Row 2419748 doesn't contain data for all columns |
| Warning | 1261 | Row 2425375 doesn't contain data for all columns |
| Warning | 1261 | Row 2665747 doesn't contain data for all columns |
| Warning | 1261 | Row 2786648 doesn't contain data for all columns |
| Warning | 1262 | Row 3017147 was truncated; it contained more data... |
| Warning | 1262 | Row 3017149 was truncated; it contained more data... |
| Warning | 1262 | Row 3492363 was truncated; it contained more data... |
| Warning | 1262 | Row 6727486 was truncated; it contained more data... |
| Warning | 1262 | Row 6796259 was truncated; it contained more data... |
| Warning | 1262 | Row 6796260 was truncated; it contained more data... |
| Warning | 1262 | Row 7301987 was truncated; it contained more data... |
| Warning | 1262 | Row 7866644 was truncated; it contained more data... |
| Warning | 1262 | Row 7866848 was truncated; it contained more data... |
14 rows in set (0.00 sec)
load data local infile '/tmp/text_memo_cd.tsv' into table text_memo_cd fields terminated by '\t' lines terminated by '\r\n' ignore 1 lines
| Warning | 1261 | Row 1170770 doesn't contain data for all columns |
| Warning | 1261 | Row 1170770 doesn't contain data for all columns |
| Warning | 1261 | Row 1170770 doesn't contain data for all columns |
| Warning | 1261 | Row 1170770 doesn't contain data for all columns |
| Warning | 1261 | Row 1170770 doesn't contain data for all columns |
| Warning | 1261 | Row 1170770 doesn't contain data for all columns |
| Warning | 1261 | Row 1283854 doesn't contain data for all columns |
| Warning | 1261 | Row 1283854 doesn't contain data for all columns |
| Warning | 1261 | Row 1283854 doesn't contain data for all columns |
| Warning | 1261 | Row 1283854 doesn't contain data for all columns |
| Warning | 1261 | Row 1283854 doesn't contain data for all columns |
| Warning | 1261 | Row 1283854 doesn't contain data for all columns |
| Warning | 1261 | Row 1283855 doesn't contain data for all columns |
| Warning | 1261 | Row 1283855 doesn't contain data for all columns |
| Warning | 1261 | Row 1283855 doesn't contain data for all columns |
| Warning | 1261 | Row 1283855 doesn't contain data for all columns |
| Warning | 1261 | Row 1283855 doesn't contain data for all columns |
| Warning | 1261 | Row 1283855 doesn't contain data for all columns |
| Warning | 1261 | Row 1283856 doesn't contain data for all columns |
| Warning | 1261 | Row 1283856 doesn't contain data for all columns |
| Warning | 1261 | Row 1283856 doesn't contain data for all columns |
| Warning | 1261 | Row 1283856 doesn't contain data for all columns |
| Warning | 1261 | Row 1283856 doesn't contain data for all columns |
| Warning | 1261 | Row 1283856 doesn't contain data for all columns |
| Warning | 1261 | Row 1315309 doesn't contain data for all columns |
| Warning | 1261 | Row 1315309 doesn't contain data for all columns |
| Warning | 1261 | Row 1315309 doesn't contain data for all columns |
| Warning | 1261 | Row 1315309 doesn't contain data for all columns |
| Warning | 1261 | Row 1315309 doesn't contain data for all columns |
| Warning | 1261 | Row 1315309 doesn't contain data for all columns |
| Warning | 1261 | Row 1319205 doesn't contain data for all columns |
| Warning | 1261 | Row 1319205 doesn't contain data for all columns |
| Warning | 1261 | Row 1319205 doesn't contain data for all columns |
| Warning | 1261 | Row 1319205 doesn't contain data for all columns |
| Warning | 1261 | Row 1319205 doesn't contain data for all columns |
| Warning | 1261 | Row 1319205 doesn't contain data for all columns |
36 rows in set (0.00 sec)
The number of warnings here need to come down to 0.
cvr_campaign_disclosure: 5 lpay: 47 rcpt: 14 text_memo: 36
data_20140228:
load data local infile '/tmp/cvr_campaign_disclosure_cd.tsv' into table cvr_campaign_disclosure_cd fields terminated by '\t' lines terminated by '\r\n' ignore 1 lines
Query OK, 276830 rows affected, 5 warnings (30.43 sec) Records: 276830 Deleted: 0 Skipped: 0 Warnings: 5 | Level | Code | Message
| Warning | 1262 | Row 340 was truncated; it contained more data... | | Warning | 1262 | Row 471 was truncated; it contained more data... | | Warning | 1262 | Row 731 was truncated; it contained more data... | | Warning | 1262 | Row 109223 was truncated; it contained more data... | | Warning | 1262 | Row 155368 was truncated; it contained more data... | 5 rows in set (0.00 sec)
load data local infile '/tmp/lpay_cd.tsv' into table lpay_cd fields terminated by '\t' lines terminated by '\r\n' ignore 1 lines
Query OK, 379046 rows affected, 47 warnings (23.96 sec) Records: 379046 Deleted: 0 Skipped: 0 Warnings: 47
show warnings
| Warning | 1262 | Row 8215 was truncated; it contained more data... | | Warning | 1262 | Row 9686 was truncated; it contained more data... | | Warning | 1262 | Row 13500 was truncated; it contained more data... | | Warning | 1262 | Row 13662 was truncated; it contained more data... | | Warning | 1262 | Row 13743 was truncated; it contained more data... | | Warning | 1262 | Row 15363 was truncated; it contained more data... | | Warning | 1262 | Row 15368 was truncated; it contained more data... | | Warning | 1262 | Row 15396 was truncated; it contained more data... | | Warning | 1262 | Row 15401 was truncated; it contained more data... | | Warning | 1262 | Row 16530 was truncated; it contained more data... | | Warning | 1262 | Row 16894 was truncated; it contained more data... | | Warning | 1262 | Row 17583 was truncated; it contained more data... | | Warning | 1262 | Row 18868 was truncated; it contained more data... | | Warning | 1262 | Row 18874 was truncated; it contained more data... | | Warning | 1262 | Row 19933 was truncated; it contained more data... | | Warning | 1262 | Row 24872 was truncated; it contained more data... | | Warning | 1262 | Row 29861 was truncated; it contained more data... | | Warning | 1262 | Row 30326 was truncated; it contained more data... | | Warning | 1262 | Row 30400 was truncated; it contained more data... | | Warning | 1262 | Row 33059 was truncated; it contained more data... | | Warning | 1262 | Row 39763 was truncated; it contained more data... | | Warning | 1262 | Row 40879 was truncated; it contained more data... | | Warning | 1262 | Row 42010 was truncated; it contained more data... | | Warning | 1262 | Row 42135 was truncated; it contained more data... | | Warning | 1262 | Row 42140 was truncated; it contained more data... | | Warning | 1262 | Row 42154 was truncated; it contained more data... | | Warning | 1262 | Row 42300 was truncated; it contained more data... | | Warning | 1262 | Row 42780 was truncated; it contained more data... | | Warning | 1262 | Row 45979 was truncated; it contained more data... | | Warning | 1262 | Row 50057 was truncated; it contained more data... | | Warning | 1262 | Row 142404 was truncated; it contained more data... | | Warning | 1262 | Row 154077 was truncated; it contained more data... | | Warning | 1262 | Row 154078 was truncated; it contained more data... | | Warning | 1262 | Row 154086 was truncated; it contained more data... | | Warning | 1262 | Row 155117 was truncated; it contained more data... | | Warning | 1262 | Row 180452 was truncated; it contained more data... | | Warning | 1262 | Row 180453 was truncated; it contained more data... | | Warning | 1262 | Row 180585 was truncated; it contained more data... | | Warning | 1262 | Row 184580 was truncated; it contained more data... | | Warning | 1262 | Row 184581 was truncated; it contained more data... | | Warning | 1262 | Row 185044 was truncated; it contained more data... | | Warning | 1262 | Row 243486 was truncated; it contained more data... | | Warning | 1262 | Row 250898 was truncated; it contained more data... | | Warning | 1262 | Row 263320 was truncated; it contained more data... | | Warning | 1262 | Row 264900 was truncated; it contained more data... | | Warning | 1262 | Row 266156 was truncated; it contained more data... | | Warning | 1262 | Row 323757 was truncated; it contained more data... | 47 rows in set (0.00 sec)
load data local infile '/tmp/rcpt_cd.tsv' into table rcpt_cd fields terminated by '\t' lines terminated by '\r\n' ignore 1 lines
Query OK, 8152422 rows affected, 14 warnings (9 min 29.67 sec) Records: 8152422 Deleted: 0 Skipped: 0 Warnings: 14
show warnings
| Warning | 1262 | Row 1075882 was truncated; it contained more data... | | Warning | 1261 | Row 2419748 doesn't contain data for all columns | | Warning | 1261 | Row 2425375 doesn't contain data for all columns | | Warning | 1261 | Row 2665747 doesn't contain data for all columns | | Warning | 1261 | Row 2786648 doesn't contain data for all columns | | Warning | 1262 | Row 3017147 was truncated; it contained more data... | | Warning | 1262 | Row 3017149 was truncated; it contained more data... | | Warning | 1262 | Row 3492363 was truncated; it contained more data... | | Warning | 1262 | Row 6727486 was truncated; it contained more data... | | Warning | 1262 | Row 6796259 was truncated; it contained more data... | | Warning | 1262 | Row 6796260 was truncated; it contained more data... | | Warning | 1262 | Row 7301987 was truncated; it contained more data... | | Warning | 1262 | Row 7866644 was truncated; it contained more data... | | Warning | 1262 | Row 7866848 was truncated; it contained more data... | 14 rows in set (0.00 sec)
load data local infile '/tmp/text_memo_cd.tsv' into table text_memo_cd fields terminated by '\t' lines terminated by '\r\n' ignore 1 lines
Query OK, 1350981 rows affected, 36 warnings (1 min 7.08 sec) Records: 1350981 Deleted: 0 Skipped: 0 Warnings: 36
show warnings
| Warning | 1261 | Row 1170770 doesn't contain data for all columns | | Warning | 1261 | Row 1170770 doesn't contain data for all columns | | Warning | 1261 | Row 1170770 doesn't contain data for all columns | | Warning | 1261 | Row 1170770 doesn't contain data for all columns | | Warning | 1261 | Row 1170770 doesn't contain data for all columns | | Warning | 1261 | Row 1170770 doesn't contain data for all columns | | Warning | 1261 | Row 1283854 doesn't contain data for all columns | | Warning | 1261 | Row 1283854 doesn't contain data for all columns | | Warning | 1261 | Row 1283854 doesn't contain data for all columns | | Warning | 1261 | Row 1283854 doesn't contain data for all columns | | Warning | 1261 | Row 1283854 doesn't contain data for all columns | | Warning | 1261 | Row 1283854 doesn't contain data for all columns | | Warning | 1261 | Row 1283855 doesn't contain data for all columns | | Warning | 1261 | Row 1283855 doesn't contain data for all columns | | Warning | 1261 | Row 1283855 doesn't contain data for all columns | | Warning | 1261 | Row 1283855 doesn't contain data for all columns | | Warning | 1261 | Row 1283855 doesn't contain data for all columns | | Warning | 1261 | Row 1283855 doesn't contain data for all columns | | Warning | 1261 | Row 1283856 doesn't contain data for all columns | | Warning | 1261 | Row 1283856 doesn't contain data for all columns | | Warning | 1261 | Row 1283856 doesn't contain data for all columns | | Warning | 1261 | Row 1283856 doesn't contain data for all columns | | Warning | 1261 | Row 1283856 doesn't contain data for all columns | | Warning | 1261 | Row 1283856 doesn't contain data for all columns | | Warning | 1261 | Row 1315309 doesn't contain data for all columns | | Warning | 1261 | Row 1315309 doesn't contain data for all columns | | Warning | 1261 | Row 1315309 doesn't contain data for all columns | | Warning | 1261 | Row 1315309 doesn't contain data for all columns | | Warning | 1261 | Row 1315309 doesn't contain data for all columns | | Warning | 1261 | Row 1315309 doesn't contain data for all columns | | Warning | 1261 | Row 1319205 doesn't contain data for all columns | | Warning | 1261 | Row 1319205 doesn't contain data for all columns | | Warning | 1261 | Row 1319205 doesn't contain data for all columns | | Warning | 1261 | Row 1319205 doesn't contain data for all columns | | Warning | 1261 | Row 1319205 doesn't contain data for all columns | | Warning | 1261 | Row 1319205 doesn't contain data for all columns | 36 rows in set (0.00 sec)