ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 33019 and state = "New Hampshire" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1055295 | 1055295 | 2021-02-22 | Sullivan | New Hampshire | 33019 | 1305 | 19 |
1052048 | 1052048 | 2021-02-21 | Sullivan | New Hampshire | 33019 | 1302 | 19 |
1048801 | 1048801 | 2021-02-20 | Sullivan | New Hampshire | 33019 | 1300 | 19 |
1045555 | 1045555 | 2021-02-19 | Sullivan | New Hampshire | 33019 | 1293 | 19 |
1042310 | 1042310 | 2021-02-18 | Sullivan | New Hampshire | 33019 | 1285 | 19 |
1039065 | 1039065 | 2021-02-17 | Sullivan | New Hampshire | 33019 | 1278 | 19 |
1035820 | 1035820 | 2021-02-16 | Sullivan | New Hampshire | 33019 | 1262 | 19 |
1032575 | 1032575 | 2021-02-15 | Sullivan | New Hampshire | 33019 | 1256 | 19 |
1029328 | 1029328 | 2021-02-14 | Sullivan | New Hampshire | 33019 | 1251 | 19 |
1026082 | 1026082 | 2021-02-13 | Sullivan | New Hampshire | 33019 | 1247 | 19 |
1022837 | 1022837 | 2021-02-12 | Sullivan | New Hampshire | 33019 | 1237 | 18 |
1019592 | 1019592 | 2021-02-11 | Sullivan | New Hampshire | 33019 | 1231 | 17 |
1016347 | 1016347 | 2021-02-10 | Sullivan | New Hampshire | 33019 | 1220 | 17 |
1013102 | 1013102 | 2021-02-09 | Sullivan | New Hampshire | 33019 | 1217 | 17 |
1009857 | 1009857 | 2021-02-08 | Sullivan | New Hampshire | 33019 | 1209 | 17 |
1006610 | 1006610 | 2021-02-07 | Sullivan | New Hampshire | 33019 | 1205 | 17 |
1003364 | 1003364 | 2021-02-06 | Sullivan | New Hampshire | 33019 | 1193 | 17 |
1000119 | 1000119 | 2021-02-05 | Sullivan | New Hampshire | 33019 | 1179 | 17 |
996873 | 996873 | 2021-02-04 | Sullivan | New Hampshire | 33019 | 1158 | 17 |
993627 | 993627 | 2021-02-03 | Sullivan | New Hampshire | 33019 | 1142 | 16 |
990381 | 990381 | 2021-02-02 | Sullivan | New Hampshire | 33019 | 1132 | 16 |
987134 | 987134 | 2021-02-01 | Sullivan | New Hampshire | 33019 | 1116 | 16 |
983887 | 983887 | 2021-01-31 | Sullivan | New Hampshire | 33019 | 1109 | 16 |
980641 | 980641 | 2021-01-30 | Sullivan | New Hampshire | 33019 | 1091 | 16 |
977395 | 977395 | 2021-01-29 | Sullivan | New Hampshire | 33019 | 1066 | 16 |
974150 | 974150 | 2021-01-28 | Sullivan | New Hampshire | 33019 | 1034 | 14 |
970905 | 970905 | 2021-01-27 | Sullivan | New Hampshire | 33019 | 1012 | 13 |
967660 | 967660 | 2021-01-26 | Sullivan | New Hampshire | 33019 | 997 | 13 |
964416 | 964416 | 2021-01-25 | Sullivan | New Hampshire | 33019 | 990 | 12 |
961171 | 961171 | 2021-01-24 | Sullivan | New Hampshire | 33019 | 979 | 12 |
957925 | 957925 | 2021-01-23 | Sullivan | New Hampshire | 33019 | 966 | 11 |
954680 | 954680 | 2021-01-22 | Sullivan | New Hampshire | 33019 | 914 | 10 |
951435 | 951435 | 2021-01-21 | Sullivan | New Hampshire | 33019 | 890 | 10 |
948189 | 948189 | 2021-01-20 | Sullivan | New Hampshire | 33019 | 876 | 9 |
944942 | 944942 | 2021-01-19 | Sullivan | New Hampshire | 33019 | 855 | 8 |
941697 | 941697 | 2021-01-18 | Sullivan | New Hampshire | 33019 | 847 | 8 |
938452 | 938452 | 2021-01-17 | Sullivan | New Hampshire | 33019 | 819 | 8 |
935207 | 935207 | 2021-01-16 | Sullivan | New Hampshire | 33019 | 792 | 8 |
931962 | 931962 | 2021-01-15 | Sullivan | New Hampshire | 33019 | 775 | 7 |
928717 | 928717 | 2021-01-14 | Sullivan | New Hampshire | 33019 | 744 | 6 |
925471 | 925471 | 2021-01-13 | Sullivan | New Hampshire | 33019 | 713 | 6 |
922226 | 922226 | 2021-01-12 | Sullivan | New Hampshire | 33019 | 680 | 6 |
918981 | 918981 | 2021-01-11 | Sullivan | New Hampshire | 33019 | 664 | 6 |
915736 | 915736 | 2021-01-10 | Sullivan | New Hampshire | 33019 | 632 | 6 |
912491 | 912491 | 2021-01-09 | Sullivan | New Hampshire | 33019 | 604 | 6 |
909246 | 909246 | 2021-01-08 | Sullivan | New Hampshire | 33019 | 588 | 6 |
906000 | 906000 | 2021-01-07 | Sullivan | New Hampshire | 33019 | 552 | 6 |
902755 | 902755 | 2021-01-06 | Sullivan | New Hampshire | 33019 | 548 | 6 |
899510 | 899510 | 2021-01-05 | Sullivan | New Hampshire | 33019 | 523 | 6 |
896265 | 896265 | 2021-01-04 | Sullivan | New Hampshire | 33019 | 509 | 6 |
893018 | 893018 | 2021-01-03 | Sullivan | New Hampshire | 33019 | 485 | 6 |
889772 | 889772 | 2021-01-02 | Sullivan | New Hampshire | 33019 | 451 | 6 |
886526 | 886526 | 2021-01-01 | Sullivan | New Hampshire | 33019 | 430 | 6 |
883281 | 883281 | 2020-12-31 | Sullivan | New Hampshire | 33019 | 430 | 6 |
880036 | 880036 | 2020-12-30 | Sullivan | New Hampshire | 33019 | 420 | 5 |
876791 | 876791 | 2020-12-29 | Sullivan | New Hampshire | 33019 | 410 | 5 |
873546 | 873546 | 2020-12-28 | Sullivan | New Hampshire | 33019 | 400 | 5 |
870301 | 870301 | 2020-12-27 | Sullivan | New Hampshire | 33019 | 388 | 5 |
867056 | 867056 | 2020-12-26 | Sullivan | New Hampshire | 33019 | 384 | 5 |
863811 | 863811 | 2020-12-25 | Sullivan | New Hampshire | 33019 | 381 | 5 |
860566 | 860566 | 2020-12-24 | Sullivan | New Hampshire | 33019 | 381 | 5 |
857321 | 857321 | 2020-12-23 | Sullivan | New Hampshire | 33019 | 376 | 5 |
854076 | 854076 | 2020-12-22 | Sullivan | New Hampshire | 33019 | 373 | 5 |
850831 | 850831 | 2020-12-21 | Sullivan | New Hampshire | 33019 | 363 | 5 |
847586 | 847586 | 2020-12-20 | Sullivan | New Hampshire | 33019 | 360 | 5 |
844340 | 844340 | 2020-12-19 | Sullivan | New Hampshire | 33019 | 349 | 5 |
841095 | 841095 | 2020-12-18 | Sullivan | New Hampshire | 33019 | 348 | 5 |
837850 | 837850 | 2020-12-17 | Sullivan | New Hampshire | 33019 | 344 | 5 |
834604 | 834604 | 2020-12-16 | Sullivan | New Hampshire | 33019 | 332 | 5 |
831357 | 831357 | 2020-12-15 | Sullivan | New Hampshire | 33019 | 328 | 5 |
828111 | 828111 | 2020-12-14 | Sullivan | New Hampshire | 33019 | 326 | 5 |
824864 | 824864 | 2020-12-13 | Sullivan | New Hampshire | 33019 | 318 | 5 |
821618 | 821618 | 2020-12-12 | Sullivan | New Hampshire | 33019 | 316 | 5 |
818372 | 818372 | 2020-12-11 | Sullivan | New Hampshire | 33019 | 306 | 5 |
815126 | 815126 | 2020-12-10 | Sullivan | New Hampshire | 33019 | 294 | 5 |
811881 | 811881 | 2020-12-09 | Sullivan | New Hampshire | 33019 | 289 | 5 |
808636 | 808636 | 2020-12-08 | Sullivan | New Hampshire | 33019 | 284 | 5 |
805391 | 805391 | 2020-12-07 | Sullivan | New Hampshire | 33019 | 280 | 5 |
802146 | 802146 | 2020-12-06 | Sullivan | New Hampshire | 33019 | 265 | 5 |
798901 | 798901 | 2020-12-05 | Sullivan | New Hampshire | 33019 | 265 | 5 |
795656 | 795656 | 2020-12-04 | Sullivan | New Hampshire | 33019 | 259 | 5 |
792411 | 792411 | 2020-12-03 | Sullivan | New Hampshire | 33019 | 249 | 5 |
789166 | 789166 | 2020-12-02 | Sullivan | New Hampshire | 33019 | 240 | 5 |
785921 | 785921 | 2020-12-01 | Sullivan | New Hampshire | 33019 | 237 | 5 |
782677 | 782677 | 2020-11-30 | Sullivan | New Hampshire | 33019 | 231 | 5 |
779431 | 779431 | 2020-11-29 | Sullivan | New Hampshire | 33019 | 229 | 5 |
776186 | 776186 | 2020-11-28 | Sullivan | New Hampshire | 33019 | 223 | 5 |
772941 | 772941 | 2020-11-27 | Sullivan | New Hampshire | 33019 | 211 | 5 |
769696 | 769696 | 2020-11-26 | Sullivan | New Hampshire | 33019 | 204 | 5 |
766450 | 766450 | 2020-11-25 | Sullivan | New Hampshire | 33019 | 204 | 5 |
763205 | 763205 | 2020-11-24 | Sullivan | New Hampshire | 33019 | 198 | 5 |
759960 | 759960 | 2020-11-23 | Sullivan | New Hampshire | 33019 | 196 | 5 |
756714 | 756714 | 2020-11-22 | Sullivan | New Hampshire | 33019 | 196 | 5 |
753467 | 753467 | 2020-11-21 | Sullivan | New Hampshire | 33019 | 192 | 4 |
750221 | 750221 | 2020-11-20 | Sullivan | New Hampshire | 33019 | 186 | 4 |
746975 | 746975 | 2020-11-19 | Sullivan | New Hampshire | 33019 | 183 | 4 |
743729 | 743729 | 2020-11-18 | Sullivan | New Hampshire | 33019 | 180 | 4 |
740482 | 740482 | 2020-11-17 | Sullivan | New Hampshire | 33019 | 177 | 4 |
737237 | 737237 | 2020-11-16 | Sullivan | New Hampshire | 33019 | 173 | 4 |
733992 | 733992 | 2020-11-15 | Sullivan | New Hampshire | 33019 | 166 | 4 |
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);