ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
803 rows where fips = 25021 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535657 | 535657 | 2020-09-15 | Norfolk | Massachusetts | 25021 | 9864 | 1034 |
532422 | 532422 | 2020-09-14 | Norfolk | Massachusetts | 25021 | 9845 | 1034 |
529186 | 529186 | 2020-09-13 | Norfolk | Massachusetts | 25021 | 9832 | 1033 |
525950 | 525950 | 2020-09-12 | Norfolk | Massachusetts | 25021 | 9809 | 1030 |
522714 | 522714 | 2020-09-11 | Norfolk | Massachusetts | 25021 | 9780 | 1029 |
519477 | 519477 | 2020-09-10 | Norfolk | Massachusetts | 25021 | 9745 | 1029 |
516242 | 516242 | 2020-09-09 | Norfolk | Massachusetts | 25021 | 9716 | 1026 |
513008 | 513008 | 2020-09-08 | Norfolk | Massachusetts | 25021 | 9704 | 1026 |
509776 | 509776 | 2020-09-07 | Norfolk | Massachusetts | 25021 | 9700 | 1022 |
506543 | 506543 | 2020-09-06 | Norfolk | Massachusetts | 25021 | 9679 | 1022 |
503310 | 503310 | 2020-09-05 | Norfolk | Massachusetts | 25021 | 9654 | 1022 |
500076 | 500076 | 2020-09-04 | Norfolk | Massachusetts | 25021 | 9620 | 1022 |
496842 | 496842 | 2020-09-03 | Norfolk | Massachusetts | 25021 | 9597 | 1021 |
493609 | 493609 | 2020-09-02 | Norfolk | Massachusetts | 25021 | 9569 | 1019 |
490375 | 490375 | 2020-09-01 | Norfolk | Massachusetts | 25021 | 11050 | 1018 |
487142 | 487142 | 2020-08-31 | Norfolk | Massachusetts | 25021 | 11033 | 1018 |
483908 | 483908 | 2020-08-30 | Norfolk | Massachusetts | 25021 | 11006 | 1017 |
480673 | 480673 | 2020-08-29 | Norfolk | Massachusetts | 25021 | 10998 | 1016 |
477441 | 477441 | 2020-08-28 | Norfolk | Massachusetts | 25021 | 10970 | 1014 |
474208 | 474208 | 2020-08-27 | Norfolk | Massachusetts | 25021 | 10942 | 1011 |
470976 | 470976 | 2020-08-26 | Norfolk | Massachusetts | 25021 | 10922 | 1008 |
467746 | 467746 | 2020-08-25 | Norfolk | Massachusetts | 25021 | 10909 | 1006 |
464517 | 464517 | 2020-08-24 | Norfolk | Massachusetts | 25021 | 10885 | 1005 |
461286 | 461286 | 2020-08-23 | Norfolk | Massachusetts | 25021 | 10845 | 1004 |
458059 | 458059 | 2020-08-22 | Norfolk | Massachusetts | 25021 | 10845 | 1004 |
454831 | 454831 | 2020-08-21 | Norfolk | Massachusetts | 25021 | 10843 | 1004 |
451603 | 451603 | 2020-08-20 | Norfolk | Massachusetts | 25021 | 10814 | 1004 |
448375 | 448375 | 2020-08-19 | Norfolk | Massachusetts | 25021 | 10796 | 1004 |
445149 | 445149 | 2020-08-18 | Norfolk | Massachusetts | 25021 | 10682 | 997 |
441923 | 441923 | 2020-08-17 | Norfolk | Massachusetts | 25021 | 10682 | 997 |
438696 | 438696 | 2020-08-16 | Norfolk | Massachusetts | 25021 | 10682 | 997 |
435471 | 435471 | 2020-08-15 | Norfolk | Massachusetts | 25021 | 10682 | 997 |
432245 | 432245 | 2020-08-14 | Norfolk | Massachusetts | 25021 | 10682 | 997 |
429018 | 429018 | 2020-08-13 | Norfolk | Massachusetts | 25021 | 10682 | 997 |
425794 | 425794 | 2020-08-12 | Norfolk | Massachusetts | 25021 | 10682 | 997 |
422572 | 422572 | 2020-08-11 | Norfolk | Massachusetts | 25021 | 10682 | 997 |
419350 | 419350 | 2020-08-10 | Norfolk | Massachusetts | 25021 | 10639 | 997 |
416129 | 416129 | 2020-08-09 | Norfolk | Massachusetts | 25021 | 10614 | 997 |
412909 | 412909 | 2020-08-08 | Norfolk | Massachusetts | 25021 | 10601 | 997 |
409689 | 409689 | 2020-08-07 | Norfolk | Massachusetts | 25021 | 10554 | 996 |
406469 | 406469 | 2020-08-06 | Norfolk | Massachusetts | 25021 | 10515 | 994 |
403251 | 403251 | 2020-08-05 | Norfolk | Massachusetts | 25021 | 10488 | 991 |
400034 | 400034 | 2020-08-04 | Norfolk | Massachusetts | 25021 | 10447 | 991 |
396820 | 396820 | 2020-08-03 | Norfolk | Massachusetts | 25021 | 10361 | 988 |
393604 | 393604 | 2020-08-02 | Norfolk | Massachusetts | 25021 | 10343 | 988 |
390387 | 390387 | 2020-08-01 | Norfolk | Massachusetts | 25021 | 10305 | 986 |
387170 | 387170 | 2020-07-31 | Norfolk | Massachusetts | 25021 | 10236 | 984 |
383952 | 383952 | 2020-07-30 | Norfolk | Massachusetts | 25021 | 10160 | 982 |
380735 | 380735 | 2020-07-29 | Norfolk | Massachusetts | 25021 | 10103 | 979 |
377518 | 377518 | 2020-07-28 | Norfolk | Massachusetts | 25021 | 10034 | 977 |
374303 | 374303 | 2020-07-27 | Norfolk | Massachusetts | 25021 | 10013 | 977 |
371091 | 371091 | 2020-07-26 | Norfolk | Massachusetts | 25021 | 9971 | 977 |
367881 | 367881 | 2020-07-25 | Norfolk | Massachusetts | 25021 | 9934 | 976 |
364674 | 364674 | 2020-07-24 | Norfolk | Massachusetts | 25021 | 9895 | 975 |
361467 | 361467 | 2020-07-23 | Norfolk | Massachusetts | 25021 | 9849 | 974 |
358262 | 358262 | 2020-07-22 | Norfolk | Massachusetts | 25021 | 9821 | 972 |
355059 | 355059 | 2020-07-21 | Norfolk | Massachusetts | 25021 | 9779 | 970 |
351857 | 351857 | 2020-07-20 | Norfolk | Massachusetts | 25021 | 9737 | 968 |
348657 | 348657 | 2020-07-19 | Norfolk | Massachusetts | 25021 | 9699 | 967 |
345456 | 345456 | 2020-07-18 | Norfolk | Massachusetts | 25021 | 9658 | 966 |
342256 | 342256 | 2020-07-17 | Norfolk | Massachusetts | 25021 | 9612 | 963 |
339060 | 339060 | 2020-07-16 | Norfolk | Massachusetts | 25021 | 9588 | 962 |
335864 | 335864 | 2020-07-15 | Norfolk | Massachusetts | 25021 | 9560 | 962 |
332671 | 332671 | 2020-07-14 | Norfolk | Massachusetts | 25021 | 9530 | 959 |
329484 | 329484 | 2020-07-13 | Norfolk | Massachusetts | 25021 | 9485 | 958 |
326298 | 326298 | 2020-07-12 | Norfolk | Massachusetts | 25021 | 9462 | 958 |
323115 | 323115 | 2020-07-11 | Norfolk | Massachusetts | 25021 | 9440 | 957 |
319936 | 319936 | 2020-07-10 | Norfolk | Massachusetts | 25021 | 9403 | 956 |
316761 | 316761 | 2020-07-09 | Norfolk | Massachusetts | 25021 | 9384 | 950 |
313587 | 313587 | 2020-07-08 | Norfolk | Massachusetts | 25021 | 9339 | 943 |
310417 | 310417 | 2020-07-07 | Norfolk | Massachusetts | 25021 | 9306 | 941 |
307249 | 307249 | 2020-07-06 | Norfolk | Massachusetts | 25021 | 9284 | 940 |
304082 | 304082 | 2020-07-05 | Norfolk | Massachusetts | 25021 | 9273 | 940 |
300918 | 300918 | 2020-07-04 | Norfolk | Massachusetts | 25021 | 9260 | 937 |
297756 | 297756 | 2020-07-03 | Norfolk | Massachusetts | 25021 | 9242 | 934 |
294598 | 294598 | 2020-07-02 | Norfolk | Massachusetts | 25021 | 9200 | 933 |
291444 | 291444 | 2020-07-01 | Norfolk | Massachusetts | 25021 | 9184 | 930 |
288293 | 288293 | 2020-06-30 | Norfolk | Massachusetts | 25021 | 9166 | 923 |
285143 | 285143 | 2020-06-29 | Norfolk | Massachusetts | 25021 | 9161 | 930 |
281998 | 281998 | 2020-06-28 | Norfolk | Massachusetts | 25021 | 9151 | 927 |
278850 | 278850 | 2020-06-27 | Norfolk | Massachusetts | 25021 | 9125 | 927 |
275702 | 275702 | 2020-06-26 | Norfolk | Massachusetts | 25021 | 9100 | 927 |
272559 | 272559 | 2020-06-25 | Norfolk | Massachusetts | 25021 | 9082 | 924 |
269422 | 269422 | 2020-06-24 | Norfolk | Massachusetts | 25021 | 9056 | 923 |
266289 | 266289 | 2020-06-23 | Norfolk | Massachusetts | 25021 | 9042 | 919 |
263163 | 263163 | 2020-06-22 | Norfolk | Massachusetts | 25021 | 9010 | 914 |
260034 | 260034 | 2020-06-21 | Norfolk | Massachusetts | 25021 | 8994 | 912 |
256908 | 256908 | 2020-06-20 | Norfolk | Massachusetts | 25021 | 8983 | 908 |
253788 | 253788 | 2020-06-19 | Norfolk | Massachusetts | 25021 | 8962 | 907 |
250673 | 250673 | 2020-06-18 | Norfolk | Massachusetts | 25021 | 8935 | 905 |
247561 | 247561 | 2020-06-17 | Norfolk | Massachusetts | 25021 | 8908 | 903 |
244448 | 244448 | 2020-06-16 | Norfolk | Massachusetts | 25021 | 8892 | 891 |
241337 | 241337 | 2020-06-15 | Norfolk | Massachusetts | 25021 | 8872 | 890 |
238228 | 238228 | 2020-06-14 | Norfolk | Massachusetts | 25021 | 8866 | 888 |
235121 | 235121 | 2020-06-13 | Norfolk | Massachusetts | 25021 | 8860 | 882 |
232016 | 232016 | 2020-06-12 | Norfolk | Massachusetts | 25021 | 8842 | 882 |
228912 | 228912 | 2020-06-11 | Norfolk | Massachusetts | 25021 | 8809 | 876 |
225810 | 225810 | 2020-06-10 | Norfolk | Massachusetts | 25021 | 8774 | 873 |
222714 | 222714 | 2020-06-09 | Norfolk | Massachusetts | 25021 | 8753 | 870 |
219619 | 219619 | 2020-06-08 | Norfolk | Massachusetts | 25021 | 8715 | 866 |
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);