ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 25009 sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
250667 | 250667 | 2020-06-18 | Essex | Massachusetts | 25009 | 15739 | 1063 |
253782 | 253782 | 2020-06-19 | Essex | Massachusetts | 25009 | 15778 | 1065 |
256902 | 256902 | 2020-06-20 | Essex | Massachusetts | 25009 | 15817 | 1071 |
260028 | 260028 | 2020-06-21 | Essex | Massachusetts | 25009 | 15829 | 1076 |
263157 | 263157 | 2020-06-22 | Essex | Massachusetts | 25009 | 15851 | 1077 |
266283 | 266283 | 2020-06-23 | Essex | Massachusetts | 25009 | 15885 | 1081 |
269416 | 269416 | 2020-06-24 | Essex | Massachusetts | 25009 | 15920 | 1083 |
272553 | 272553 | 2020-06-25 | Essex | Massachusetts | 25009 | 15952 | 1086 |
275696 | 275696 | 2020-06-26 | Essex | Massachusetts | 25009 | 15975 | 1092 |
278844 | 278844 | 2020-06-27 | Essex | Massachusetts | 25009 | 16028 | 1096 |
281992 | 281992 | 2020-06-28 | Essex | Massachusetts | 25009 | 16053 | 1099 |
285137 | 285137 | 2020-06-29 | Essex | Massachusetts | 25009 | 16069 | 1106 |
288287 | 288287 | 2020-06-30 | Essex | Massachusetts | 25009 | 16088 | 1104 |
291438 | 291438 | 2020-07-01 | Essex | Massachusetts | 25009 | 16122 | 1104 |
294592 | 294592 | 2020-07-02 | Essex | Massachusetts | 25009 | 16176 | 1111 |
297750 | 297750 | 2020-07-03 | Essex | Massachusetts | 25009 | 16210 | 1116 |
300912 | 300912 | 2020-07-04 | Essex | Massachusetts | 25009 | 16235 | 1119 |
304076 | 304076 | 2020-07-05 | Essex | Massachusetts | 25009 | 16254 | 1119 |
307243 | 307243 | 2020-07-06 | Essex | Massachusetts | 25009 | 16283 | 1122 |
310411 | 310411 | 2020-07-07 | Essex | Massachusetts | 25009 | 16318 | 1126 |
313581 | 313581 | 2020-07-08 | Essex | Massachusetts | 25009 | 16342 | 1131 |
316755 | 316755 | 2020-07-09 | Essex | Massachusetts | 25009 | 16379 | 1133 |
319930 | 319930 | 2020-07-10 | Essex | Massachusetts | 25009 | 16414 | 1136 |
323109 | 323109 | 2020-07-11 | Essex | Massachusetts | 25009 | 16452 | 1136 |
326292 | 326292 | 2020-07-12 | Essex | Massachusetts | 25009 | 16469 | 1137 |
329478 | 329478 | 2020-07-13 | Essex | Massachusetts | 25009 | 16485 | 1136 |
332665 | 332665 | 2020-07-14 | Essex | Massachusetts | 25009 | 16530 | 1136 |
335858 | 335858 | 2020-07-15 | Essex | Massachusetts | 25009 | 16564 | 1136 |
339054 | 339054 | 2020-07-16 | Essex | Massachusetts | 25009 | 16596 | 1136 |
342250 | 342250 | 2020-07-17 | Essex | Massachusetts | 25009 | 16632 | 1139 |
345450 | 345450 | 2020-07-18 | Essex | Massachusetts | 25009 | 16710 | 1140 |
348651 | 348651 | 2020-07-19 | Essex | Massachusetts | 25009 | 16733 | 1143 |
351851 | 351851 | 2020-07-20 | Essex | Massachusetts | 25009 | 16757 | 1143 |
355053 | 355053 | 2020-07-21 | Essex | Massachusetts | 25009 | 16784 | 1146 |
358256 | 358256 | 2020-07-22 | Essex | Massachusetts | 25009 | 16815 | 1152 |
361461 | 361461 | 2020-07-23 | Essex | Massachusetts | 25009 | 16856 | 1157 |
364668 | 364668 | 2020-07-24 | Essex | Massachusetts | 25009 | 16883 | 1159 |
367875 | 367875 | 2020-07-25 | Essex | Massachusetts | 25009 | 16915 | 1162 |
371085 | 371085 | 2020-07-26 | Essex | Massachusetts | 25009 | 16952 | 1167 |
374297 | 374297 | 2020-07-27 | Essex | Massachusetts | 25009 | 16990 | 1169 |
377512 | 377512 | 2020-07-28 | Essex | Massachusetts | 25009 | 17033 | 1170 |
380729 | 380729 | 2020-07-29 | Essex | Massachusetts | 25009 | 17119 | 1175 |
383946 | 383946 | 2020-07-30 | Essex | Massachusetts | 25009 | 17169 | 1177 |
387164 | 387164 | 2020-07-31 | Essex | Massachusetts | 25009 | 17232 | 1177 |
390381 | 390381 | 2020-08-01 | Essex | Massachusetts | 25009 | 17305 | 1182 |
393598 | 393598 | 2020-08-02 | Essex | Massachusetts | 25009 | 17386 | 1183 |
396814 | 396814 | 2020-08-03 | Essex | Massachusetts | 25009 | 17422 | 1185 |
400028 | 400028 | 2020-08-04 | Essex | Massachusetts | 25009 | 17494 | 1186 |
403245 | 403245 | 2020-08-05 | Essex | Massachusetts | 25009 | 17571 | 1186 |
406463 | 406463 | 2020-08-06 | Essex | Massachusetts | 25009 | 17617 | 1190 |
409683 | 409683 | 2020-08-07 | Essex | Massachusetts | 25009 | 17699 | 1191 |
412903 | 412903 | 2020-08-08 | Essex | Massachusetts | 25009 | 17789 | 1192 |
416123 | 416123 | 2020-08-09 | Essex | Massachusetts | 25009 | 17846 | 1193 |
419344 | 419344 | 2020-08-10 | Essex | Massachusetts | 25009 | 17883 | 1194 |
422566 | 422566 | 2020-08-11 | Essex | Massachusetts | 25009 | 17930 | 1194 |
425788 | 425788 | 2020-08-12 | Essex | Massachusetts | 25009 | 17930 | 1194 |
429012 | 429012 | 2020-08-13 | Essex | Massachusetts | 25009 | 17930 | 1194 |
432239 | 432239 | 2020-08-14 | Essex | Massachusetts | 25009 | 17930 | 1194 |
435465 | 435465 | 2020-08-15 | Essex | Massachusetts | 25009 | 17930 | 1194 |
438690 | 438690 | 2020-08-16 | Essex | Massachusetts | 25009 | 17930 | 1194 |
441917 | 441917 | 2020-08-17 | Essex | Massachusetts | 25009 | 17930 | 1194 |
445143 | 445143 | 2020-08-18 | Essex | Massachusetts | 25009 | 17930 | 1194 |
448369 | 448369 | 2020-08-19 | Essex | Massachusetts | 25009 | 18291 | 1205 |
451597 | 451597 | 2020-08-20 | Essex | Massachusetts | 25009 | 18343 | 1207 |
454825 | 454825 | 2020-08-21 | Essex | Massachusetts | 25009 | 18406 | 1210 |
458053 | 458053 | 2020-08-22 | Essex | Massachusetts | 25009 | 18430 | 1215 |
461280 | 461280 | 2020-08-23 | Essex | Massachusetts | 25009 | 18430 | 1215 |
464511 | 464511 | 2020-08-24 | Essex | Massachusetts | 25009 | 18510 | 1220 |
467740 | 467740 | 2020-08-25 | Essex | Massachusetts | 25009 | 18563 | 1222 |
470970 | 470970 | 2020-08-26 | Essex | Massachusetts | 25009 | 18628 | 1226 |
474202 | 474202 | 2020-08-27 | Essex | Massachusetts | 25009 | 18680 | 1228 |
477435 | 477435 | 2020-08-28 | Essex | Massachusetts | 25009 | 18756 | 1231 |
480667 | 480667 | 2020-08-29 | Essex | Massachusetts | 25009 | 18808 | 1234 |
483902 | 483902 | 2020-08-30 | Essex | Massachusetts | 25009 | 18835 | 1236 |
487136 | 487136 | 2020-08-31 | Essex | Massachusetts | 25009 | 18863 | 1239 |
490369 | 490369 | 2020-09-01 | Essex | Massachusetts | 25009 | 18912 | 1240 |
493603 | 493603 | 2020-09-02 | Essex | Massachusetts | 25009 | 18125 | 1241 |
496836 | 496836 | 2020-09-03 | Essex | Massachusetts | 25009 | 18186 | 1243 |
500070 | 500070 | 2020-09-04 | Essex | Massachusetts | 25009 | 18249 | 1249 |
503304 | 503304 | 2020-09-05 | Essex | Massachusetts | 25009 | 18316 | 1251 |
506537 | 506537 | 2020-09-06 | Essex | Massachusetts | 25009 | 18382 | 1253 |
509770 | 509770 | 2020-09-07 | Essex | Massachusetts | 25009 | 18398 | 1253 |
513002 | 513002 | 2020-09-08 | Essex | Massachusetts | 25009 | 18431 | 1254 |
516236 | 516236 | 2020-09-09 | Essex | Massachusetts | 25009 | 18454 | 1256 |
519471 | 519471 | 2020-09-10 | Essex | Massachusetts | 25009 | 18508 | 1257 |
522708 | 522708 | 2020-09-11 | Essex | Massachusetts | 25009 | 18580 | 1258 |
525944 | 525944 | 2020-09-12 | Essex | Massachusetts | 25009 | 18643 | 1258 |
529180 | 529180 | 2020-09-13 | Essex | Massachusetts | 25009 | 18679 | 1260 |
532416 | 532416 | 2020-09-14 | Essex | Massachusetts | 25009 | 18703 | 1260 |
535651 | 535651 | 2020-09-15 | Essex | Massachusetts | 25009 | 18746 | 1261 |
538888 | 538888 | 2020-09-16 | Essex | Massachusetts | 25009 | 18770 | 1261 |
542124 | 542124 | 2020-09-17 | Essex | Massachusetts | 25009 | 18815 | 1262 |
545361 | 545361 | 2020-09-18 | Essex | Massachusetts | 25009 | 18872 | 1262 |
548599 | 548599 | 2020-09-19 | Essex | Massachusetts | 25009 | 19022 | 1266 |
551838 | 551838 | 2020-09-20 | Essex | Massachusetts | 25009 | 19074 | 1268 |
555076 | 555076 | 2020-09-21 | Essex | Massachusetts | 25009 | 19086 | 1269 |
558313 | 558313 | 2020-09-22 | Essex | Massachusetts | 25009 | 19120 | 1271 |
561550 | 561550 | 2020-09-23 | Essex | Massachusetts | 25009 | 19305 | 1273 |
564790 | 564790 | 2020-09-24 | Essex | Massachusetts | 25009 | 19422 | 1274 |
568030 | 568030 | 2020-09-25 | Essex | Massachusetts | 25009 | 19525 | 1275 |
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);