ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Union" and fips = 12125 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917577 | 917577 | 2021-01-11 | Union | Florida | 12125 | 1559 | 66 |
914332 | 914332 | 2021-01-10 | Union | Florida | 12125 | 1556 | 66 |
911087 | 911087 | 2021-01-09 | Union | Florida | 12125 | 1552 | 66 |
907842 | 907842 | 2021-01-08 | Union | Florida | 12125 | 1545 | 67 |
904596 | 904596 | 2021-01-07 | Union | Florida | 12125 | 1515 | 65 |
901351 | 901351 | 2021-01-06 | Union | Florida | 12125 | 1500 | 65 |
898106 | 898106 | 2021-01-05 | Union | Florida | 12125 | 1490 | 65 |
894861 | 894861 | 2021-01-04 | Union | Florida | 12125 | 1481 | 65 |
891614 | 891614 | 2021-01-03 | Union | Florida | 12125 | 1480 | 65 |
888367 | 888367 | 2021-01-02 | Union | Florida | 12125 | 1473 | 65 |
885122 | 885122 | 2021-01-01 | Union | Florida | 12125 | 1439 | 65 |
881877 | 881877 | 2020-12-31 | Union | Florida | 12125 | 1439 | 65 |
878632 | 878632 | 2020-12-30 | Union | Florida | 12125 | 1431 | 65 |
875387 | 875387 | 2020-12-29 | Union | Florida | 12125 | 1428 | 65 |
872142 | 872142 | 2020-12-28 | Union | Florida | 12125 | 1416 | 65 |
868897 | 868897 | 2020-12-27 | Union | Florida | 12125 | 1414 | 65 |
865652 | 865652 | 2020-12-26 | Union | Florida | 12125 | 1413 | 65 |
862407 | 862407 | 2020-12-25 | Union | Florida | 12125 | 1388 | 65 |
859162 | 859162 | 2020-12-24 | Union | Florida | 12125 | 1388 | 65 |
855917 | 855917 | 2020-12-23 | Union | Florida | 12125 | 1382 | 65 |
852672 | 852672 | 2020-12-22 | Union | Florida | 12125 | 1373 | 65 |
849427 | 849427 | 2020-12-21 | Union | Florida | 12125 | 1368 | 65 |
846182 | 846182 | 2020-12-20 | Union | Florida | 12125 | 1365 | 65 |
842936 | 842936 | 2020-12-19 | Union | Florida | 12125 | 1359 | 65 |
839691 | 839691 | 2020-12-18 | Union | Florida | 12125 | 1343 | 65 |
836446 | 836446 | 2020-12-17 | Union | Florida | 12125 | 1342 | 65 |
833200 | 833200 | 2020-12-16 | Union | Florida | 12125 | 1333 | 65 |
829953 | 829953 | 2020-12-15 | Union | Florida | 12125 | 1325 | 63 |
826707 | 826707 | 2020-12-14 | Union | Florida | 12125 | 1306 | 62 |
823460 | 823460 | 2020-12-13 | Union | Florida | 12125 | 1305 | 61 |
820214 | 820214 | 2020-12-12 | Union | Florida | 12125 | 1302 | 61 |
816968 | 816968 | 2020-12-11 | Union | Florida | 12125 | 1293 | 61 |
813722 | 813722 | 2020-12-10 | Union | Florida | 12125 | 1285 | 61 |
810478 | 810478 | 2020-12-09 | Union | Florida | 12125 | 1279 | 61 |
807233 | 807233 | 2020-12-08 | Union | Florida | 12125 | 1267 | 61 |
803988 | 803988 | 2020-12-07 | Union | Florida | 12125 | 1261 | 61 |
800743 | 800743 | 2020-12-06 | Union | Florida | 12125 | 1259 | 61 |
797498 | 797498 | 2020-12-05 | Union | Florida | 12125 | 1254 | 61 |
794253 | 794253 | 2020-12-04 | Union | Florida | 12125 | 1249 | 61 |
791008 | 791008 | 2020-12-03 | Union | Florida | 12125 | 1242 | 61 |
787763 | 787763 | 2020-12-02 | Union | Florida | 12125 | 1240 | 61 |
784519 | 784519 | 2020-12-01 | Union | Florida | 12125 | 1238 | 61 |
781274 | 781274 | 2020-11-30 | Union | Florida | 12125 | 1229 | 61 |
778028 | 778028 | 2020-11-29 | Union | Florida | 12125 | 1227 | 59 |
774783 | 774783 | 2020-11-28 | Union | Florida | 12125 | 1225 | 59 |
771538 | 771538 | 2020-11-27 | Union | Florida | 12125 | 1224 | 59 |
768293 | 768293 | 2020-11-26 | Union | Florida | 12125 | 1215 | 59 |
765047 | 765047 | 2020-11-25 | Union | Florida | 12125 | 1215 | 59 |
761802 | 761802 | 2020-11-24 | Union | Florida | 12125 | 1212 | 59 |
758557 | 758557 | 2020-11-23 | Union | Florida | 12125 | 1210 | 59 |
755310 | 755310 | 2020-11-22 | Union | Florida | 12125 | 1210 | 58 |
752064 | 752064 | 2020-11-21 | Union | Florida | 12125 | 1208 | 58 |
748818 | 748818 | 2020-11-20 | Union | Florida | 12125 | 1205 | 57 |
745572 | 745572 | 2020-11-19 | Union | Florida | 12125 | 1201 | 57 |
742325 | 742325 | 2020-11-18 | Union | Florida | 12125 | 1199 | 53 |
739078 | 739078 | 2020-11-17 | Union | Florida | 12125 | 1197 | 53 |
735834 | 735834 | 2020-11-16 | Union | Florida | 12125 | 1194 | 53 |
732588 | 732588 | 2020-11-15 | Union | Florida | 12125 | 1193 | 53 |
729343 | 729343 | 2020-11-14 | Union | Florida | 12125 | 1191 | 53 |
726100 | 726100 | 2020-11-13 | Union | Florida | 12125 | 1190 | 53 |
722857 | 722857 | 2020-11-12 | Union | Florida | 12125 | 1190 | 53 |
719614 | 719614 | 2020-11-11 | Union | Florida | 12125 | 1190 | 53 |
716371 | 716371 | 2020-11-10 | Union | Florida | 12125 | 1187 | 53 |
713127 | 713127 | 2020-11-09 | Union | Florida | 12125 | 1180 | 49 |
709883 | 709883 | 2020-11-08 | Union | Florida | 12125 | 1177 | 49 |
706639 | 706639 | 2020-11-07 | Union | Florida | 12125 | 1175 | 49 |
703396 | 703396 | 2020-11-06 | Union | Florida | 12125 | 1174 | 47 |
700153 | 700153 | 2020-11-05 | Union | Florida | 12125 | 1172 | 47 |
696909 | 696909 | 2020-11-04 | Union | Florida | 12125 | 1167 | 47 |
693667 | 693667 | 2020-11-03 | Union | Florida | 12125 | 1159 | 45 |
690424 | 690424 | 2020-11-02 | Union | Florida | 12125 | 1151 | 45 |
687179 | 687179 | 2020-11-01 | Union | Florida | 12125 | 1147 | 45 |
683935 | 683935 | 2020-10-31 | Union | Florida | 12125 | 1139 | 45 |
680692 | 680692 | 2020-10-30 | Union | Florida | 12125 | 1138 | 45 |
677449 | 677449 | 2020-10-29 | Union | Florida | 12125 | 1133 | 44 |
674206 | 674206 | 2020-10-28 | Union | Florida | 12125 | 1129 | 43 |
670964 | 670964 | 2020-10-27 | Union | Florida | 12125 | 1126 | 43 |
667721 | 667721 | 2020-10-26 | Union | Florida | 12125 | 1121 | 43 |
664476 | 664476 | 2020-10-25 | Union | Florida | 12125 | 1118 | 41 |
661232 | 661232 | 2020-10-24 | Union | Florida | 12125 | 1117 | 41 |
657988 | 657988 | 2020-10-23 | Union | Florida | 12125 | 1111 | 41 |
654743 | 654743 | 2020-10-22 | Union | Florida | 12125 | 1106 | 41 |
651498 | 651498 | 2020-10-21 | Union | Florida | 12125 | 1092 | 29 |
648254 | 648254 | 2020-10-20 | Union | Florida | 12125 | 1086 | 29 |
645009 | 645009 | 2020-10-19 | Union | Florida | 12125 | 1082 | 28 |
641761 | 641761 | 2020-10-18 | Union | Florida | 12125 | 1081 | 27 |
638514 | 638514 | 2020-10-17 | Union | Florida | 12125 | 1077 | 27 |
635269 | 635269 | 2020-10-16 | Union | Florida | 12125 | 1066 | 27 |
632023 | 632023 | 2020-10-15 | Union | Florida | 12125 | 1058 | 26 |
628779 | 628779 | 2020-10-14 | Union | Florida | 12125 | 1041 | 25 |
625536 | 625536 | 2020-10-13 | Union | Florida | 12125 | 1037 | 25 |
622293 | 622293 | 2020-10-12 | Union | Florida | 12125 | 1029 | 25 |
619050 | 619050 | 2020-10-11 | Union | Florida | 12125 | 1029 | 25 |
615808 | 615808 | 2020-10-10 | Union | Florida | 12125 | 1016 | 24 |
612567 | 612567 | 2020-10-09 | Union | Florida | 12125 | 1016 | 24 |
609325 | 609325 | 2020-10-08 | Union | Florida | 12125 | 1012 | 23 |
606082 | 606082 | 2020-10-07 | Union | Florida | 12125 | 1009 | 23 |
602840 | 602840 | 2020-10-06 | Union | Florida | 12125 | 1001 | 23 |
599597 | 599597 | 2020-10-05 | Union | Florida | 12125 | 1000 | 18 |
596354 | 596354 | 2020-10-04 | Union | Florida | 12125 | 992 | 18 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);