ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
755 rows where fips = 23021 and state = "Maine" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535616 | 535616 | 2020-09-15 | Piscataquis | Maine | 23021 | 8 | 0 |
532381 | 532381 | 2020-09-14 | Piscataquis | Maine | 23021 | 8 | 0 |
529144 | 529144 | 2020-09-13 | Piscataquis | Maine | 23021 | 8 | 0 |
525908 | 525908 | 2020-09-12 | Piscataquis | Maine | 23021 | 8 | 0 |
522672 | 522672 | 2020-09-11 | Piscataquis | Maine | 23021 | 8 | 0 |
519435 | 519435 | 2020-09-10 | Piscataquis | Maine | 23021 | 8 | 0 |
516200 | 516200 | 2020-09-09 | Piscataquis | Maine | 23021 | 8 | 0 |
512967 | 512967 | 2020-09-08 | Piscataquis | Maine | 23021 | 8 | 0 |
509735 | 509735 | 2020-09-07 | Piscataquis | Maine | 23021 | 8 | 0 |
506502 | 506502 | 2020-09-06 | Piscataquis | Maine | 23021 | 8 | 0 |
503268 | 503268 | 2020-09-05 | Piscataquis | Maine | 23021 | 8 | 0 |
500035 | 500035 | 2020-09-04 | Piscataquis | Maine | 23021 | 8 | 0 |
496801 | 496801 | 2020-09-03 | Piscataquis | Maine | 23021 | 8 | 0 |
493568 | 493568 | 2020-09-02 | Piscataquis | Maine | 23021 | 8 | 0 |
490334 | 490334 | 2020-09-01 | Piscataquis | Maine | 23021 | 8 | 0 |
487101 | 487101 | 2020-08-31 | Piscataquis | Maine | 23021 | 8 | 0 |
483866 | 483866 | 2020-08-30 | Piscataquis | Maine | 23021 | 8 | 0 |
480632 | 480632 | 2020-08-29 | Piscataquis | Maine | 23021 | 8 | 0 |
477399 | 477399 | 2020-08-28 | Piscataquis | Maine | 23021 | 8 | 0 |
474166 | 474166 | 2020-08-27 | Piscataquis | Maine | 23021 | 8 | 0 |
470934 | 470934 | 2020-08-26 | Piscataquis | Maine | 23021 | 8 | 0 |
467705 | 467705 | 2020-08-25 | Piscataquis | Maine | 23021 | 7 | 0 |
464476 | 464476 | 2020-08-24 | Piscataquis | Maine | 23021 | 7 | 0 |
461245 | 461245 | 2020-08-23 | Piscataquis | Maine | 23021 | 7 | 0 |
458018 | 458018 | 2020-08-22 | Piscataquis | Maine | 23021 | 7 | 0 |
454790 | 454790 | 2020-08-21 | Piscataquis | Maine | 23021 | 7 | 0 |
451562 | 451562 | 2020-08-20 | Piscataquis | Maine | 23021 | 7 | 0 |
448334 | 448334 | 2020-08-19 | Piscataquis | Maine | 23021 | 7 | 0 |
445107 | 445107 | 2020-08-18 | Piscataquis | Maine | 23021 | 12 | 0 |
441881 | 441881 | 2020-08-17 | Piscataquis | Maine | 23021 | 12 | 0 |
438654 | 438654 | 2020-08-16 | Piscataquis | Maine | 23021 | 11 | 0 |
435429 | 435429 | 2020-08-15 | Piscataquis | Maine | 23021 | 11 | 0 |
432204 | 432204 | 2020-08-14 | Piscataquis | Maine | 23021 | 6 | 0 |
428976 | 428976 | 2020-08-13 | Piscataquis | Maine | 23021 | 6 | 0 |
425752 | 425752 | 2020-08-12 | Piscataquis | Maine | 23021 | 4 | 0 |
422531 | 422531 | 2020-08-11 | Piscataquis | Maine | 23021 | 4 | 0 |
419309 | 419309 | 2020-08-10 | Piscataquis | Maine | 23021 | 4 | 0 |
416088 | 416088 | 2020-08-09 | Piscataquis | Maine | 23021 | 4 | 0 |
412868 | 412868 | 2020-08-08 | Piscataquis | Maine | 23021 | 3 | 0 |
409648 | 409648 | 2020-08-07 | Piscataquis | Maine | 23021 | 3 | 0 |
406428 | 406428 | 2020-08-06 | Piscataquis | Maine | 23021 | 3 | 0 |
403210 | 403210 | 2020-08-05 | Piscataquis | Maine | 23021 | 3 | 0 |
399993 | 399993 | 2020-08-04 | Piscataquis | Maine | 23021 | 3 | 0 |
396778 | 396778 | 2020-08-03 | Piscataquis | Maine | 23021 | 3 | 0 |
393562 | 393562 | 2020-08-02 | Piscataquis | Maine | 23021 | 3 | 0 |
390345 | 390345 | 2020-08-01 | Piscataquis | Maine | 23021 | 3 | 0 |
387128 | 387128 | 2020-07-31 | Piscataquis | Maine | 23021 | 3 | 0 |
383910 | 383910 | 2020-07-30 | Piscataquis | Maine | 23021 | 3 | 0 |
380693 | 380693 | 2020-07-29 | Piscataquis | Maine | 23021 | 3 | 0 |
377476 | 377476 | 2020-07-28 | Piscataquis | Maine | 23021 | 3 | 0 |
374261 | 374261 | 2020-07-27 | Piscataquis | Maine | 23021 | 3 | 0 |
371049 | 371049 | 2020-07-26 | Piscataquis | Maine | 23021 | 3 | 0 |
367839 | 367839 | 2020-07-25 | Piscataquis | Maine | 23021 | 3 | 0 |
364632 | 364632 | 2020-07-24 | Piscataquis | Maine | 23021 | 3 | 0 |
361425 | 361425 | 2020-07-23 | Piscataquis | Maine | 23021 | 3 | 0 |
358220 | 358220 | 2020-07-22 | Piscataquis | Maine | 23021 | 4 | 0 |
355017 | 355017 | 2020-07-21 | Piscataquis | Maine | 23021 | 4 | 0 |
351815 | 351815 | 2020-07-20 | Piscataquis | Maine | 23021 | 4 | 0 |
348615 | 348615 | 2020-07-19 | Piscataquis | Maine | 23021 | 4 | 0 |
345414 | 345414 | 2020-07-18 | Piscataquis | Maine | 23021 | 4 | 0 |
342214 | 342214 | 2020-07-17 | Piscataquis | Maine | 23021 | 4 | 0 |
339018 | 339018 | 2020-07-16 | Piscataquis | Maine | 23021 | 4 | 0 |
335822 | 335822 | 2020-07-15 | Piscataquis | Maine | 23021 | 4 | 0 |
332629 | 332629 | 2020-07-14 | Piscataquis | Maine | 23021 | 5 | 0 |
329442 | 329442 | 2020-07-13 | Piscataquis | Maine | 23021 | 5 | 0 |
326256 | 326256 | 2020-07-12 | Piscataquis | Maine | 23021 | 5 | 0 |
323073 | 323073 | 2020-07-11 | Piscataquis | Maine | 23021 | 5 | 0 |
319894 | 319894 | 2020-07-10 | Piscataquis | Maine | 23021 | 5 | 0 |
316719 | 316719 | 2020-07-09 | Piscataquis | Maine | 23021 | 5 | 0 |
313545 | 313545 | 2020-07-08 | Piscataquis | Maine | 23021 | 4 | 0 |
310375 | 310375 | 2020-07-07 | Piscataquis | Maine | 23021 | 4 | 0 |
307207 | 307207 | 2020-07-06 | Piscataquis | Maine | 23021 | 4 | 0 |
304040 | 304040 | 2020-07-05 | Piscataquis | Maine | 23021 | 4 | 0 |
300876 | 300876 | 2020-07-04 | Piscataquis | Maine | 23021 | 3 | 0 |
297714 | 297714 | 2020-07-03 | Piscataquis | Maine | 23021 | 3 | 0 |
294556 | 294556 | 2020-07-02 | Piscataquis | Maine | 23021 | 3 | 0 |
291402 | 291402 | 2020-07-01 | Piscataquis | Maine | 23021 | 3 | 0 |
288251 | 288251 | 2020-06-30 | Piscataquis | Maine | 23021 | 3 | 0 |
285102 | 285102 | 2020-06-29 | Piscataquis | Maine | 23021 | 3 | 0 |
281956 | 281956 | 2020-06-28 | Piscataquis | Maine | 23021 | 3 | 0 |
278808 | 278808 | 2020-06-27 | Piscataquis | Maine | 23021 | 3 | 0 |
275660 | 275660 | 2020-06-26 | Piscataquis | Maine | 23021 | 2 | 0 |
272517 | 272517 | 2020-06-25 | Piscataquis | Maine | 23021 | 2 | 0 |
269381 | 269381 | 2020-06-24 | Piscataquis | Maine | 23021 | 2 | 0 |
266248 | 266248 | 2020-06-23 | Piscataquis | Maine | 23021 | 2 | 0 |
263121 | 263121 | 2020-06-22 | Piscataquis | Maine | 23021 | 2 | 0 |
259992 | 259992 | 2020-06-21 | Piscataquis | Maine | 23021 | 2 | 0 |
256866 | 256866 | 2020-06-20 | Piscataquis | Maine | 23021 | 2 | 0 |
253746 | 253746 | 2020-06-19 | Piscataquis | Maine | 23021 | 1 | 0 |
250631 | 250631 | 2020-06-18 | Piscataquis | Maine | 23021 | 1 | 0 |
247519 | 247519 | 2020-06-17 | Piscataquis | Maine | 23021 | 1 | 0 |
244406 | 244406 | 2020-06-16 | Piscataquis | Maine | 23021 | 1 | 0 |
241295 | 241295 | 2020-06-15 | Piscataquis | Maine | 23021 | 1 | 0 |
238186 | 238186 | 2020-06-14 | Piscataquis | Maine | 23021 | 1 | 0 |
235079 | 235079 | 2020-06-13 | Piscataquis | Maine | 23021 | 1 | 0 |
231974 | 231974 | 2020-06-12 | Piscataquis | Maine | 23021 | 1 | 0 |
228870 | 228870 | 2020-06-11 | Piscataquis | Maine | 23021 | 1 | 0 |
225768 | 225768 | 2020-06-10 | Piscataquis | Maine | 23021 | 1 | 0 |
222672 | 222672 | 2020-06-09 | Piscataquis | Maine | 23021 | 1 | 0 |
219577 | 219577 | 2020-06-08 | Piscataquis | Maine | 23021 | 1 | 0 |
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);