ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Franklin" and fips = 25011 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535652 | 535652 | 2020-09-15 | Franklin | Massachusetts | 25011 | 397 | 67 |
532417 | 532417 | 2020-09-14 | Franklin | Massachusetts | 25011 | 396 | 67 |
529181 | 529181 | 2020-09-13 | Franklin | Massachusetts | 25011 | 396 | 67 |
525945 | 525945 | 2020-09-12 | Franklin | Massachusetts | 25011 | 396 | 66 |
522709 | 522709 | 2020-09-11 | Franklin | Massachusetts | 25011 | 396 | 66 |
519472 | 519472 | 2020-09-10 | Franklin | Massachusetts | 25011 | 396 | 66 |
516237 | 516237 | 2020-09-09 | Franklin | Massachusetts | 25011 | 396 | 66 |
513003 | 513003 | 2020-09-08 | Franklin | Massachusetts | 25011 | 396 | 66 |
509771 | 509771 | 2020-09-07 | Franklin | Massachusetts | 25011 | 396 | 66 |
506538 | 506538 | 2020-09-06 | Franklin | Massachusetts | 25011 | 396 | 66 |
503305 | 503305 | 2020-09-05 | Franklin | Massachusetts | 25011 | 396 | 66 |
500071 | 500071 | 2020-09-04 | Franklin | Massachusetts | 25011 | 394 | 66 |
496837 | 496837 | 2020-09-03 | Franklin | Massachusetts | 25011 | 392 | 66 |
493604 | 493604 | 2020-09-02 | Franklin | Massachusetts | 25011 | 392 | 66 |
490370 | 490370 | 2020-09-01 | Franklin | Massachusetts | 25011 | 431 | 65 |
487137 | 487137 | 2020-08-31 | Franklin | Massachusetts | 25011 | 430 | 65 |
483903 | 483903 | 2020-08-30 | Franklin | Massachusetts | 25011 | 428 | 65 |
480668 | 480668 | 2020-08-29 | Franklin | Massachusetts | 25011 | 428 | 64 |
477436 | 477436 | 2020-08-28 | Franklin | Massachusetts | 25011 | 426 | 64 |
474203 | 474203 | 2020-08-27 | Franklin | Massachusetts | 25011 | 426 | 63 |
470971 | 470971 | 2020-08-26 | Franklin | Massachusetts | 25011 | 424 | 63 |
467741 | 467741 | 2020-08-25 | Franklin | Massachusetts | 25011 | 421 | 61 |
464512 | 464512 | 2020-08-24 | Franklin | Massachusetts | 25011 | 420 | 61 |
461281 | 461281 | 2020-08-23 | Franklin | Massachusetts | 25011 | 419 | 61 |
458054 | 458054 | 2020-08-22 | Franklin | Massachusetts | 25011 | 419 | 61 |
454826 | 454826 | 2020-08-21 | Franklin | Massachusetts | 25011 | 419 | 61 |
451598 | 451598 | 2020-08-20 | Franklin | Massachusetts | 25011 | 416 | 61 |
448370 | 448370 | 2020-08-19 | Franklin | Massachusetts | 25011 | 414 | 61 |
445144 | 445144 | 2020-08-18 | Franklin | Massachusetts | 25011 | 411 | 61 |
441918 | 441918 | 2020-08-17 | Franklin | Massachusetts | 25011 | 411 | 61 |
438691 | 438691 | 2020-08-16 | Franklin | Massachusetts | 25011 | 411 | 61 |
435466 | 435466 | 2020-08-15 | Franklin | Massachusetts | 25011 | 411 | 61 |
432240 | 432240 | 2020-08-14 | Franklin | Massachusetts | 25011 | 411 | 61 |
429013 | 429013 | 2020-08-13 | Franklin | Massachusetts | 25011 | 411 | 61 |
425789 | 425789 | 2020-08-12 | Franklin | Massachusetts | 25011 | 411 | 61 |
422567 | 422567 | 2020-08-11 | Franklin | Massachusetts | 25011 | 411 | 61 |
419345 | 419345 | 2020-08-10 | Franklin | Massachusetts | 25011 | 411 | 61 |
416124 | 416124 | 2020-08-09 | Franklin | Massachusetts | 25011 | 411 | 61 |
412904 | 412904 | 2020-08-08 | Franklin | Massachusetts | 25011 | 411 | 61 |
409684 | 409684 | 2020-08-07 | Franklin | Massachusetts | 25011 | 410 | 61 |
406464 | 406464 | 2020-08-06 | Franklin | Massachusetts | 25011 | 409 | 61 |
403246 | 403246 | 2020-08-05 | Franklin | Massachusetts | 25011 | 407 | 61 |
400029 | 400029 | 2020-08-04 | Franklin | Massachusetts | 25011 | 406 | 60 |
396815 | 396815 | 2020-08-03 | Franklin | Massachusetts | 25011 | 405 | 60 |
393599 | 393599 | 2020-08-02 | Franklin | Massachusetts | 25011 | 405 | 60 |
390382 | 390382 | 2020-08-01 | Franklin | Massachusetts | 25011 | 404 | 60 |
387165 | 387165 | 2020-07-31 | Franklin | Massachusetts | 25011 | 402 | 60 |
383947 | 383947 | 2020-07-30 | Franklin | Massachusetts | 25011 | 398 | 60 |
380730 | 380730 | 2020-07-29 | Franklin | Massachusetts | 25011 | 397 | 60 |
377513 | 377513 | 2020-07-28 | Franklin | Massachusetts | 25011 | 398 | 59 |
374298 | 374298 | 2020-07-27 | Franklin | Massachusetts | 25011 | 396 | 59 |
371086 | 371086 | 2020-07-26 | Franklin | Massachusetts | 25011 | 396 | 59 |
367876 | 367876 | 2020-07-25 | Franklin | Massachusetts | 25011 | 393 | 59 |
364669 | 364669 | 2020-07-24 | Franklin | Massachusetts | 25011 | 391 | 58 |
361462 | 361462 | 2020-07-23 | Franklin | Massachusetts | 25011 | 391 | 57 |
358257 | 358257 | 2020-07-22 | Franklin | Massachusetts | 25011 | 390 | 57 |
355054 | 355054 | 2020-07-21 | Franklin | Massachusetts | 25011 | 390 | 57 |
351852 | 351852 | 2020-07-20 | Franklin | Massachusetts | 25011 | 390 | 57 |
348652 | 348652 | 2020-07-19 | Franklin | Massachusetts | 25011 | 391 | 58 |
345451 | 345451 | 2020-07-18 | Franklin | Massachusetts | 25011 | 391 | 58 |
342251 | 342251 | 2020-07-17 | Franklin | Massachusetts | 25011 | 389 | 58 |
339055 | 339055 | 2020-07-16 | Franklin | Massachusetts | 25011 | 386 | 58 |
335859 | 335859 | 2020-07-15 | Franklin | Massachusetts | 25011 | 385 | 58 |
332666 | 332666 | 2020-07-14 | Franklin | Massachusetts | 25011 | 384 | 57 |
329479 | 329479 | 2020-07-13 | Franklin | Massachusetts | 25011 | 384 | 57 |
326293 | 326293 | 2020-07-12 | Franklin | Massachusetts | 25011 | 384 | 57 |
323110 | 323110 | 2020-07-11 | Franklin | Massachusetts | 25011 | 384 | 57 |
319931 | 319931 | 2020-07-10 | Franklin | Massachusetts | 25011 | 383 | 56 |
316756 | 316756 | 2020-07-09 | Franklin | Massachusetts | 25011 | 381 | 56 |
313582 | 313582 | 2020-07-08 | Franklin | Massachusetts | 25011 | 376 | 55 |
310412 | 310412 | 2020-07-07 | Franklin | Massachusetts | 25011 | 373 | 55 |
307244 | 307244 | 2020-07-06 | Franklin | Massachusetts | 25011 | 373 | 55 |
304077 | 304077 | 2020-07-05 | Franklin | Massachusetts | 25011 | 373 | 55 |
300913 | 300913 | 2020-07-04 | Franklin | Massachusetts | 25011 | 373 | 55 |
297751 | 297751 | 2020-07-03 | Franklin | Massachusetts | 25011 | 372 | 55 |
294593 | 294593 | 2020-07-02 | Franklin | Massachusetts | 25011 | 372 | 55 |
291439 | 291439 | 2020-07-01 | Franklin | Massachusetts | 25011 | 370 | 55 |
288288 | 288288 | 2020-06-30 | Franklin | Massachusetts | 25011 | 366 | 54 |
285138 | 285138 | 2020-06-29 | Franklin | Massachusetts | 25011 | 366 | 54 |
281993 | 281993 | 2020-06-28 | Franklin | Massachusetts | 25011 | 366 | 54 |
278845 | 278845 | 2020-06-27 | Franklin | Massachusetts | 25011 | 366 | 54 |
275697 | 275697 | 2020-06-26 | Franklin | Massachusetts | 25011 | 364 | 54 |
272554 | 272554 | 2020-06-25 | Franklin | Massachusetts | 25011 | 362 | 54 |
269417 | 269417 | 2020-06-24 | Franklin | Massachusetts | 25011 | 359 | 53 |
266284 | 266284 | 2020-06-23 | Franklin | Massachusetts | 25011 | 359 | 53 |
263158 | 263158 | 2020-06-22 | Franklin | Massachusetts | 25011 | 358 | 53 |
260029 | 260029 | 2020-06-21 | Franklin | Massachusetts | 25011 | 358 | 53 |
256903 | 256903 | 2020-06-20 | Franklin | Massachusetts | 25011 | 358 | 53 |
253783 | 253783 | 2020-06-19 | Franklin | Massachusetts | 25011 | 357 | 52 |
250668 | 250668 | 2020-06-18 | Franklin | Massachusetts | 25011 | 356 | 52 |
247556 | 247556 | 2020-06-17 | Franklin | Massachusetts | 25011 | 354 | 52 |
244443 | 244443 | 2020-06-16 | Franklin | Massachusetts | 25011 | 353 | 51 |
241332 | 241332 | 2020-06-15 | Franklin | Massachusetts | 25011 | 353 | 51 |
238223 | 238223 | 2020-06-14 | Franklin | Massachusetts | 25011 | 353 | 51 |
235116 | 235116 | 2020-06-13 | Franklin | Massachusetts | 25011 | 353 | 50 |
232011 | 232011 | 2020-06-12 | Franklin | Massachusetts | 25011 | 348 | 50 |
228907 | 228907 | 2020-06-11 | Franklin | Massachusetts | 25011 | 348 | 49 |
225805 | 225805 | 2020-06-10 | Franklin | Massachusetts | 25011 | 344 | 49 |
222709 | 222709 | 2020-06-09 | Franklin | Massachusetts | 25011 | 341 | 49 |
219614 | 219614 | 2020-06-08 | Franklin | Massachusetts | 25011 | 338 | 49 |
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);