ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 25015 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
278847 | 278847 | 2020-06-27 | Hampshire | Massachusetts | 25015 | 955 | 110 |
281995 | 281995 | 2020-06-28 | Hampshire | Massachusetts | 25015 | 958 | 110 |
285140 | 285140 | 2020-06-29 | Hampshire | Massachusetts | 25015 | 959 | 110 |
288290 | 288290 | 2020-06-30 | Hampshire | Massachusetts | 25015 | 962 | 110 |
291441 | 291441 | 2020-07-01 | Hampshire | Massachusetts | 25015 | 965 | 112 |
294595 | 294595 | 2020-07-02 | Hampshire | Massachusetts | 25015 | 969 | 114 |
297753 | 297753 | 2020-07-03 | Hampshire | Massachusetts | 25015 | 976 | 115 |
300915 | 300915 | 2020-07-04 | Hampshire | Massachusetts | 25015 | 982 | 116 |
304079 | 304079 | 2020-07-05 | Hampshire | Massachusetts | 25015 | 985 | 116 |
307246 | 307246 | 2020-07-06 | Hampshire | Massachusetts | 25015 | 985 | 116 |
310414 | 310414 | 2020-07-07 | Hampshire | Massachusetts | 25015 | 986 | 116 |
313584 | 313584 | 2020-07-08 | Hampshire | Massachusetts | 25015 | 991 | 116 |
316758 | 316758 | 2020-07-09 | Hampshire | Massachusetts | 25015 | 993 | 117 |
319933 | 319933 | 2020-07-10 | Hampshire | Massachusetts | 25015 | 995 | 117 |
323112 | 323112 | 2020-07-11 | Hampshire | Massachusetts | 25015 | 1001 | 117 |
326295 | 326295 | 2020-07-12 | Hampshire | Massachusetts | 25015 | 1008 | 117 |
329481 | 329481 | 2020-07-13 | Hampshire | Massachusetts | 25015 | 1008 | 117 |
332668 | 332668 | 2020-07-14 | Hampshire | Massachusetts | 25015 | 1012 | 117 |
335861 | 335861 | 2020-07-15 | Hampshire | Massachusetts | 25015 | 1012 | 118 |
339057 | 339057 | 2020-07-16 | Hampshire | Massachusetts | 25015 | 1015 | 119 |
342253 | 342253 | 2020-07-17 | Hampshire | Massachusetts | 25015 | 1026 | 119 |
345453 | 345453 | 2020-07-18 | Hampshire | Massachusetts | 25015 | 1033 | 119 |
348654 | 348654 | 2020-07-19 | Hampshire | Massachusetts | 25015 | 1039 | 120 |
351854 | 351854 | 2020-07-20 | Hampshire | Massachusetts | 25015 | 1049 | 123 |
355056 | 355056 | 2020-07-21 | Hampshire | Massachusetts | 25015 | 1057 | 125 |
358259 | 358259 | 2020-07-22 | Hampshire | Massachusetts | 25015 | 1063 | 125 |
361464 | 361464 | 2020-07-23 | Hampshire | Massachusetts | 25015 | 1065 | 125 |
364671 | 364671 | 2020-07-24 | Hampshire | Massachusetts | 25015 | 1076 | 125 |
367878 | 367878 | 2020-07-25 | Hampshire | Massachusetts | 25015 | 1082 | 126 |
371088 | 371088 | 2020-07-26 | Hampshire | Massachusetts | 25015 | 1090 | 126 |
374300 | 374300 | 2020-07-27 | Hampshire | Massachusetts | 25015 | 1095 | 127 |
377515 | 377515 | 2020-07-28 | Hampshire | Massachusetts | 25015 | 1095 | 127 |
380732 | 380732 | 2020-07-29 | Hampshire | Massachusetts | 25015 | 1102 | 127 |
383949 | 383949 | 2020-07-30 | Hampshire | Massachusetts | 25015 | 1107 | 127 |
387167 | 387167 | 2020-07-31 | Hampshire | Massachusetts | 25015 | 1126 | 127 |
390384 | 390384 | 2020-08-01 | Hampshire | Massachusetts | 25015 | 1132 | 127 |
393601 | 393601 | 2020-08-02 | Hampshire | Massachusetts | 25015 | 1136 | 127 |
396817 | 396817 | 2020-08-03 | Hampshire | Massachusetts | 25015 | 1139 | 127 |
400031 | 400031 | 2020-08-04 | Hampshire | Massachusetts | 25015 | 1145 | 127 |
403248 | 403248 | 2020-08-05 | Hampshire | Massachusetts | 25015 | 1150 | 127 |
406466 | 406466 | 2020-08-06 | Hampshire | Massachusetts | 25015 | 1158 | 128 |
409686 | 409686 | 2020-08-07 | Hampshire | Massachusetts | 25015 | 1162 | 129 |
412906 | 412906 | 2020-08-08 | Hampshire | Massachusetts | 25015 | 1170 | 129 |
416126 | 416126 | 2020-08-09 | Hampshire | Massachusetts | 25015 | 1174 | 129 |
419347 | 419347 | 2020-08-10 | Hampshire | Massachusetts | 25015 | 1179 | 129 |
422569 | 422569 | 2020-08-11 | Hampshire | Massachusetts | 25015 | 1184 | 130 |
425791 | 425791 | 2020-08-12 | Hampshire | Massachusetts | 25015 | 1184 | 130 |
429015 | 429015 | 2020-08-13 | Hampshire | Massachusetts | 25015 | 1184 | 130 |
432242 | 432242 | 2020-08-14 | Hampshire | Massachusetts | 25015 | 1184 | 130 |
435468 | 435468 | 2020-08-15 | Hampshire | Massachusetts | 25015 | 1184 | 130 |
438693 | 438693 | 2020-08-16 | Hampshire | Massachusetts | 25015 | 1184 | 130 |
441920 | 441920 | 2020-08-17 | Hampshire | Massachusetts | 25015 | 1184 | 130 |
445146 | 445146 | 2020-08-18 | Hampshire | Massachusetts | 25015 | 1184 | 130 |
448372 | 448372 | 2020-08-19 | Hampshire | Massachusetts | 25015 | 1221 | 131 |
451600 | 451600 | 2020-08-20 | Hampshire | Massachusetts | 25015 | 1224 | 131 |
454828 | 454828 | 2020-08-21 | Hampshire | Massachusetts | 25015 | 1230 | 133 |
458056 | 458056 | 2020-08-22 | Hampshire | Massachusetts | 25015 | 1230 | 133 |
461283 | 461283 | 2020-08-23 | Hampshire | Massachusetts | 25015 | 1230 | 133 |
464514 | 464514 | 2020-08-24 | Hampshire | Massachusetts | 25015 | 1244 | 134 |
467743 | 467743 | 2020-08-25 | Hampshire | Massachusetts | 25015 | 1249 | 135 |
470973 | 470973 | 2020-08-26 | Hampshire | Massachusetts | 25015 | 1253 | 136 |
474205 | 474205 | 2020-08-27 | Hampshire | Massachusetts | 25015 | 1258 | 136 |
477438 | 477438 | 2020-08-28 | Hampshire | Massachusetts | 25015 | 1267 | 137 |
480670 | 480670 | 2020-08-29 | Hampshire | Massachusetts | 25015 | 1276 | 138 |
483905 | 483905 | 2020-08-30 | Hampshire | Massachusetts | 25015 | 1279 | 138 |
487139 | 487139 | 2020-08-31 | Hampshire | Massachusetts | 25015 | 1281 | 140 |
490372 | 490372 | 2020-09-01 | Hampshire | Massachusetts | 25015 | 1287 | 140 |
493606 | 493606 | 2020-09-02 | Hampshire | Massachusetts | 25015 | 1176 | 140 |
496839 | 496839 | 2020-09-03 | Hampshire | Massachusetts | 25015 | 1180 | 140 |
500073 | 500073 | 2020-09-04 | Hampshire | Massachusetts | 25015 | 1183 | 141 |
503307 | 503307 | 2020-09-05 | Hampshire | Massachusetts | 25015 | 1186 | 141 |
506540 | 506540 | 2020-09-06 | Hampshire | Massachusetts | 25015 | 1188 | 141 |
509773 | 509773 | 2020-09-07 | Hampshire | Massachusetts | 25015 | 1189 | 141 |
513005 | 513005 | 2020-09-08 | Hampshire | Massachusetts | 25015 | 1191 | 141 |
516239 | 516239 | 2020-09-09 | Hampshire | Massachusetts | 25015 | 1191 | 141 |
519474 | 519474 | 2020-09-10 | Hampshire | Massachusetts | 25015 | 1193 | 141 |
522711 | 522711 | 2020-09-11 | Hampshire | Massachusetts | 25015 | 1194 | 141 |
525947 | 525947 | 2020-09-12 | Hampshire | Massachusetts | 25015 | 1196 | 141 |
529183 | 529183 | 2020-09-13 | Hampshire | Massachusetts | 25015 | 1196 | 141 |
532419 | 532419 | 2020-09-14 | Hampshire | Massachusetts | 25015 | 1196 | 141 |
535654 | 535654 | 2020-09-15 | Hampshire | Massachusetts | 25015 | 1198 | 141 |
538891 | 538891 | 2020-09-16 | Hampshire | Massachusetts | 25015 | 1199 | 141 |
542127 | 542127 | 2020-09-17 | Hampshire | Massachusetts | 25015 | 1200 | 141 |
545364 | 545364 | 2020-09-18 | Hampshire | Massachusetts | 25015 | 1203 | 141 |
548602 | 548602 | 2020-09-19 | Hampshire | Massachusetts | 25015 | 1205 | 141 |
551841 | 551841 | 2020-09-20 | Hampshire | Massachusetts | 25015 | 1206 | 141 |
555079 | 555079 | 2020-09-21 | Hampshire | Massachusetts | 25015 | 1206 | 141 |
558316 | 558316 | 2020-09-22 | Hampshire | Massachusetts | 25015 | 1205 | 141 |
561553 | 561553 | 2020-09-23 | Hampshire | Massachusetts | 25015 | 1208 | 142 |
564793 | 564793 | 2020-09-24 | Hampshire | Massachusetts | 25015 | 1211 | 143 |
568033 | 568033 | 2020-09-25 | Hampshire | Massachusetts | 25015 | 1214 | 143 |
571275 | 571275 | 2020-09-26 | Hampshire | Massachusetts | 25015 | 1222 | 143 |
574518 | 574518 | 2020-09-27 | Hampshire | Massachusetts | 25015 | 1226 | 144 |
577759 | 577759 | 2020-09-28 | Hampshire | Massachusetts | 25015 | 1230 | 144 |
581000 | 581000 | 2020-09-29 | Hampshire | Massachusetts | 25015 | 1235 | 144 |
584241 | 584241 | 2020-09-30 | Hampshire | Massachusetts | 25015 | 1251 | 144 |
587481 | 587481 | 2020-10-01 | Hampshire | Massachusetts | 25015 | 1273 | 145 |
590722 | 590722 | 2020-10-02 | Hampshire | Massachusetts | 25015 | 1298 | 147 |
593963 | 593963 | 2020-10-03 | Hampshire | Massachusetts | 25015 | 1316 | 148 |
597204 | 597204 | 2020-10-04 | Hampshire | Massachusetts | 25015 | 1324 | 148 |
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);