search

rkiddy / open_calaccess_data_perl

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.
0 stars 0 forks source link

Some problem filing_date values in FILER_FILINGS.TSV #6

Closed rkiddy closed 10 years ago

rkiddy commented 10 years ago

mysql> select * from filer_filings where filing_date < '1970' order by filing_date, filing_id; +--------+----------+-----------+-----------+---------+-----------------+-------------+------------+--------------+------------+----------+---------------+------------+------------+------------+----------+-------------+ | pk | filer_id | filing_id | period_id | form_id | filing_sequence | filing_date | stmnt_type | stmnt_status | session_id | user_id | special_audit | fine_audit | rpt_start | rpt_end | rpt_date | filing_type | +--------+----------+-----------+-----------+---------+-----------------+-------------+------------+--------------+------------+----------+---------------+------------+------------+------------+----------+-------------+ | 73637 | 1014222 | 77419 | 157 | F461 | 0 | 1900-01-01 | 10001 | 11001 | 1999 | * | 11001 | 11001 | 1999-01-01 | 1999-06-30 | NULL | NULL | | 539596 | 1064536 | 577406 | 0 | F999 | 0 | 1900-01-12 | 10005 | 11003 | 1999 | * | 11003 | 11003 | NULL | NULL | NULL | NULL | | 540855 | 1076063 | 577408 | 0 | F999 | 0 | 1900-01-19 | 10005 | 11003 | 1999 | * | 11003 | 11003 | NULL | NULL | NULL | NULL | | 559784 | 1018886 | 620430 | 0 | F496 | 0 | 1900-02-26 | 10005 | 11003 | 1999 | * | 11003 | 11003 | NULL | NULL | NULL | NULL | | 559785 | 1018886 | 620432 | 0 | F496 | 0 | 1900-02-26 | 10005 | 11003 | 1999 | * | 11003 | 11003 | NULL | NULL | NULL | NULL | | 559786 | 1018886 | 620434 | 0 | F496 | 0 | 1900-02-26 | 10005 | 11003 | 1999 | * | 11003 | 11003 | NULL | NULL | NULL | NULL | | 559787 | 1018886 | 620436 | 0 | F496 | 0 | 1900-02-26 | 10005 | 11003 | 1999 | * | 11003 | 11003 | NULL | NULL | NULL | NULL | | 559788 | 1018886 | 620438 | 0 | F496 | 0 | 1900-02-26 | 10005 | 11003 | 1999 | * | 11003 | 11003 | NULL | NULL | NULL | NULL | | 566233 | 1075518 | 593129 | 0 | F460 | 1 | 1900-03-06 | 10006 | 11001 | 1999 | TTHAM | 11003 | 11003 | 2000-01-23 | 2000-02-19 | NULL | NULL | | 564386 | 1222580 | 621284 | 0 | F410 | 0 | 1900-03-22 | 10001 | 11003 | 1999 | * | 11003 | 11003 | NULL | NULL | NULL | NULL | | 564718 | 1146171 | 623790 | 0 | F690 | 0 | 1900-03-31 | 10005 | 11001 | 1999 | TTHAM | 11003 | 11003 | 1999-04-01 | 1999-06-30 | NULL | NULL | | 569719 | 1144947 | 635701 | 0 | F999 | 0 | 1900-04-21 | 10005 | 11001 | 1999 | TTHAM | 11003 | 11003 | NULL | NULL | NULL | NULL | | 614259 | 1223860 | 635039 | 0 | F635 | 1 | 1900-05-09 | 10006 | 11003 | 1999 | DHORRELL | 11003 | 11003 | 2000-01-01 | 2000-01-31 | NULL | NULL | | 571165 | 1224590 | 637981 | 0 | F602 | 0 | 1900-06-30 | 10005 | 11001 | 1999 | CFLAGG | 11003 | 11003 | NULL | NULL | NULL | NULL | | 575760 | 1145689 | 642221 | 162 | F635 | 0 | 1900-07-19 | 10005 | 11001 | 1999 | TTHAM | 11003 | 11003 | 2000-04-01 | 2000-06-30 | NULL | NULL | | 572162 | 1076602 | 646354 | 0 | F460 | 0 | 1900-07-31 | 10005 | 11003 | 1999 | FWALKER | 11003 | 11003 | 2000-02-20 | 2000-06-30 | NULL | NULL | | 109408 | 1019150 | 107736 | 0 | F497 | 0 | 1900-09-22 | 10001 | 11001 | 1899 | * | 11001 | 11001 | NULL | NULL | NULL | NULL | | 398333 | 1071589 | 404703 | 0 | F410 | 0 | 1909-10-14 | 10001 | 11001 | 1909 | * | 11001 | 11001 | NULL | NULL | NULL | NULL | | 135351 | 1022020 | 130135 | 140 | F420 | 0 | 1910-10-24 | 10001 | 11001 | 1993 | * | 11001 | 11001 | 1994-10-01 | 1994-10-22 | NULL | NULL | | 333466 | 1051393 | 327054 | 140 | F420 | 0 | 1910-10-25 | 10001 | 11001 | 1993 | * | 11001 | 11001 | 1994-10-01 | 1994-10-22 | NULL | NULL | | 333467 | 1051393 | 327055 | 140 | F420 | 0 | 1910-10-25 | 10001 | 11001 | 1993 | * | 11001 | 11001 | 1994-10-23 | 1994-11-07 | NULL | NULL | | 238162 | 1037581 | 253009 | 139 | F420 | 0 | 1910-10-27 | 10001 | 11001 | 1993 | * | 11001 | 11001 | 1994-07-01 | 1994-10-22 | NULL | NULL | | 251718 | 1039079 | 261522 | 140 | F420 | 0 | 1910-10-27 | 10001 | 11001 | 1993 | * | 11001 | 11001 | 1994-10-01 | 1994-10-22 | NULL | NULL | | 374597 | 1062568 | 374634 | 137 | F420 | 0 | 1910-10-27 | 10001 | 11001 | 1993 | * | 11001 | 11001 | 1994-01-01 | 1994-10-22 | NULL | NULL | | 303349 | 1049404 | 316927 | 131 | F419 | 0 | 1911-01-28 | 10001 | 11001 | 1991 | * | 11001 | 11001 | 1992-07-01 | 1992-12-31 | NULL | NULL | | 323636 | 1051010 | 325010 | 132 | F419 | 0 | 1911-01-29 | 10001 | 11001 | 1991 | * | 11001 | 11001 | 1992-10-18 | 1992-12-31 | NULL | NULL | | 95774 | 1018501 | 90527 | 127 | F420 | 0 | 1917-02-02 | 10001 | 11001 | 1991 | * | 11001 | 11001 | 1991-07-01 | 1991-12-31 | NULL | NULL | | 367118 | 1061731 | 371737 | 138 | F490 | 0 | 1919-05-26 | 10001 | 11001 | 1993 | * | 11001 | 11001 | 1994-04-17 | 1994-05-21 | NULL | NULL | | 221403 | 1034391 | 234240 | 0 | F497 | 0 | 1923-10-28 | 10001 | 11001 | 1923 | * | 11001 | 11001 | NULL | NULL | NULL | NULL | | 353955 | 1058448 | 356548 | 0 | F497 | 0 | 1923-10-28 | 10001 | 11001 | 1923 | * | 11001 | 11001 | NULL | NULL | NULL | NULL | | 362420 | 1060253 | 364667 | 0 | F405 | 0 | 1923-10-29 | 10001 | 11001 | 1923 | * | 11001 | 11001 | NULL | NULL | NULL | NULL | | 365382 | 1061598 | 371226 | 0 | F410 | 0 | 1924-03-02 | 10001 | 11001 | 1923 | * | 11001 | 11001 | NULL | NULL | NULL | NULL | | 103368 | 1018836 | 100253 | 138 | F420 | 0 | 1934-07-14 | 10001 | 11001 | 1993 | * | 11001 | 11001 | 1994-05-22 | 1994-06-30 | NULL | NULL | | 328293 | 1051679 | 328339 | 0 | F415 | 0 | 1937-08-02 | 10001 | 11001 | 1937 | * | 11001 | 11001 | NULL | NULL | NULL | NULL | | 102848 | 1018823 | 99806 | 138 | F490 | 0 | 1940-07-29 | 10001 | 11001 | 1993 | * | 11001 | 11001 | 1994-05-22 | 1994-06-30 | NULL | NULL | | 360981 | 1059097 | 359909 | 137 | F405 | 0 | 1940-07-29 | 10001 | 11001 | 1993 | * | 11001 | 11001 | 1994-01-01 | 1994-03-17 | NULL | NULL | | 411779 | 1059097 | 438340 | 137 | F405 | 0 | 1940-07-29 | 10001 | 11001 | 1993 | * | 11001 | 11001 | 1994-03-18 | 1994-05-21 | NULL | NULL | | 25000 | 1002710 | 26576 | 139 | F490 | 0 | 1944-10-04 | 10001 | 11001 | 1993 | * | 11001 | 11001 | 1994-07-01 | 1994-09-30 | NULL | NULL | | 29782 | 1004620 | 34287 | 139 | F490 | 0 | 1944-10-04 | 10001 | 11001 | 1993 | * | 11001 | 11001 | 1994-07-01 | 1994-09-30 | NULL | NULL | | 29787 | 1004622 | 34292 | 139 | F490 | 0 | 1944-10-04 | 10001 | 11001 | 1993 | * | 11001 | 11001 | 1994-07-01 | 1994-09-30 | NULL | NULL | | 30094 | 1004625 | 34300 | 139 | F490 | 0 | 1944-10-04 | 10001 | 11001 | 1993 | * | 11001 | 11001 | 1994-07-01 | 1994-09-30 | NULL | NULL | | 63668 | 1004624 | 199139 | 139 | F490 | 0 | 1944-10-04 | 10001 | 11001 | 1993 | * | 11001 | 11001 | 1994-07-01 | 1994-09-30 | NULL | NULL | | 359418 | 1058931 | 358881 | 0 | F497 | 0 | 1944-10-26 | 10001 | 11001 | 1943 | * | 11001 | 11001 | NULL | NULL | NULL | NULL | | 259452 | 1041364 | 272869 | 0 | F497 | 0 | 1944-11-04 | 10001 | 11001 | 1943 | * | 11001 | 11001 | NULL | NULL | NULL | NULL | | 104440 | 1019165 | 108231 | 155 | F450 | 0 | 1948-10-01 | 10001 | 11001 | 1997 | * | 11001 | 11001 | 1998-07-01 | 1998-09-30 | NULL | NULL | | 484405 | 1143800 | 485012 | 145 | F635 | 0 | 1960-04-29 | 10001 | 11001 | 1995 | * | 11001 | 11001 | 1996-01-01 | 1996-03-31 | NULL | NULL | | 73490 | 1011369 | 69940 | 123 | F461 | 0 | 1961-01-30 | 10001 | 11001 | 1989 | * | 11001 | 11001 | 1990-07-01 | 1990-12-31 | NULL | NULL | | 489236 | 1143466 | 484479 | 145 | F635 | 0 | 1966-01-01 | 10001 | 11001 | 1995 | * | 11001 | 11001 | 1996-01-01 | 1996-03-31 | NULL | NULL | | 34027 | 1003858 | 32861 | 31 | F416 | 0 | 1967-09-21 | 10001 | 11001 | 1967 | * | 11001 | 11001 | NULL | NULL | NULL | NULL | | 386947 | 1067123 | 391857 | 37 | F405 | 0 | 1969-02-22 | 10001 | 11001 | 1969 | * | 11001 | 11001 | NULL | NULL | NULL | NULL | | 420946 | 1072796 | 445457 | 156 | F490 | 0 | 1969-10-16 | 10001 | 11001 | 1997 | * | 11001 | 11001 | 1998-10-01 | 1998-10-22 | NULL | NULL | +--------+----------+-----------+-----------+---------+-----------------+-------------+------------+--------------+------------+----------+---------------+------------+------------+------------+----------+-------------+ 51 rows in set (0.00 sec)

rkiddy commented 10 years ago

Forgot I already have an issue for this.