ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where fips = 23009 and state = "Maine" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535610 | 535610 | 2020-09-15 | Hancock | Maine | 23009 | 53 | 1 |
532375 | 532375 | 2020-09-14 | Hancock | Maine | 23009 | 53 | 1 |
529138 | 529138 | 2020-09-13 | Hancock | Maine | 23009 | 52 | 1 |
525902 | 525902 | 2020-09-12 | Hancock | Maine | 23009 | 52 | 1 |
522666 | 522666 | 2020-09-11 | Hancock | Maine | 23009 | 52 | 1 |
519429 | 519429 | 2020-09-10 | Hancock | Maine | 23009 | 51 | 1 |
516194 | 516194 | 2020-09-09 | Hancock | Maine | 23009 | 51 | 1 |
512961 | 512961 | 2020-09-08 | Hancock | Maine | 23009 | 51 | 1 |
509729 | 509729 | 2020-09-07 | Hancock | Maine | 23009 | 50 | 1 |
506496 | 506496 | 2020-09-06 | Hancock | Maine | 23009 | 50 | 1 |
503262 | 503262 | 2020-09-05 | Hancock | Maine | 23009 | 50 | 1 |
500029 | 500029 | 2020-09-04 | Hancock | Maine | 23009 | 50 | 1 |
496795 | 496795 | 2020-09-03 | Hancock | Maine | 23009 | 50 | 1 |
493562 | 493562 | 2020-09-02 | Hancock | Maine | 23009 | 47 | 1 |
490328 | 490328 | 2020-09-01 | Hancock | Maine | 23009 | 47 | 1 |
487095 | 487095 | 2020-08-31 | Hancock | Maine | 23009 | 45 | 1 |
483860 | 483860 | 2020-08-30 | Hancock | Maine | 23009 | 45 | 1 |
480626 | 480626 | 2020-08-29 | Hancock | Maine | 23009 | 45 | 1 |
477393 | 477393 | 2020-08-28 | Hancock | Maine | 23009 | 45 | 1 |
474160 | 474160 | 2020-08-27 | Hancock | Maine | 23009 | 46 | 1 |
470928 | 470928 | 2020-08-26 | Hancock | Maine | 23009 | 46 | 1 |
467699 | 467699 | 2020-08-25 | Hancock | Maine | 23009 | 46 | 1 |
464470 | 464470 | 2020-08-24 | Hancock | Maine | 23009 | 46 | 1 |
461239 | 461239 | 2020-08-23 | Hancock | Maine | 23009 | 46 | 1 |
458012 | 458012 | 2020-08-22 | Hancock | Maine | 23009 | 45 | 1 |
454784 | 454784 | 2020-08-21 | Hancock | Maine | 23009 | 44 | 1 |
451556 | 451556 | 2020-08-20 | Hancock | Maine | 23009 | 42 | 1 |
448328 | 448328 | 2020-08-19 | Hancock | Maine | 23009 | 42 | 1 |
445101 | 445101 | 2020-08-18 | Hancock | Maine | 23009 | 40 | 1 |
441875 | 441875 | 2020-08-17 | Hancock | Maine | 23009 | 40 | 1 |
438648 | 438648 | 2020-08-16 | Hancock | Maine | 23009 | 40 | 1 |
435423 | 435423 | 2020-08-15 | Hancock | Maine | 23009 | 40 | 1 |
432198 | 432198 | 2020-08-14 | Hancock | Maine | 23009 | 40 | 1 |
428970 | 428970 | 2020-08-13 | Hancock | Maine | 23009 | 40 | 1 |
425746 | 425746 | 2020-08-12 | Hancock | Maine | 23009 | 37 | 1 |
422525 | 422525 | 2020-08-11 | Hancock | Maine | 23009 | 36 | 1 |
419303 | 419303 | 2020-08-10 | Hancock | Maine | 23009 | 36 | 1 |
416082 | 416082 | 2020-08-09 | Hancock | Maine | 23009 | 35 | 1 |
412862 | 412862 | 2020-08-08 | Hancock | Maine | 23009 | 35 | 1 |
409642 | 409642 | 2020-08-07 | Hancock | Maine | 23009 | 35 | 1 |
406422 | 406422 | 2020-08-06 | Hancock | Maine | 23009 | 35 | 1 |
403204 | 403204 | 2020-08-05 | Hancock | Maine | 23009 | 36 | 1 |
399987 | 399987 | 2020-08-04 | Hancock | Maine | 23009 | 34 | 1 |
396772 | 396772 | 2020-08-03 | Hancock | Maine | 23009 | 34 | 1 |
393556 | 393556 | 2020-08-02 | Hancock | Maine | 23009 | 34 | 1 |
390339 | 390339 | 2020-08-01 | Hancock | Maine | 23009 | 27 | 1 |
387122 | 387122 | 2020-07-31 | Hancock | Maine | 23009 | 27 | 1 |
383904 | 383904 | 2020-07-30 | Hancock | Maine | 23009 | 27 | 1 |
380687 | 380687 | 2020-07-29 | Hancock | Maine | 23009 | 23 | 1 |
377470 | 377470 | 2020-07-28 | Hancock | Maine | 23009 | 18 | 1 |
374255 | 374255 | 2020-07-27 | Hancock | Maine | 23009 | 19 | 1 |
371043 | 371043 | 2020-07-26 | Hancock | Maine | 23009 | 19 | 1 |
367833 | 367833 | 2020-07-25 | Hancock | Maine | 23009 | 19 | 1 |
364626 | 364626 | 2020-07-24 | Hancock | Maine | 23009 | 19 | 1 |
361419 | 361419 | 2020-07-23 | Hancock | Maine | 23009 | 19 | 1 |
358214 | 358214 | 2020-07-22 | Hancock | Maine | 23009 | 21 | 1 |
355011 | 355011 | 2020-07-21 | Hancock | Maine | 23009 | 19 | 1 |
351809 | 351809 | 2020-07-20 | Hancock | Maine | 23009 | 19 | 1 |
348609 | 348609 | 2020-07-19 | Hancock | Maine | 23009 | 19 | 1 |
345408 | 345408 | 2020-07-18 | Hancock | Maine | 23009 | 19 | 1 |
342208 | 342208 | 2020-07-17 | Hancock | Maine | 23009 | 19 | 1 |
339012 | 339012 | 2020-07-16 | Hancock | Maine | 23009 | 19 | 1 |
335816 | 335816 | 2020-07-15 | Hancock | Maine | 23009 | 18 | 1 |
332623 | 332623 | 2020-07-14 | Hancock | Maine | 23009 | 18 | 1 |
329436 | 329436 | 2020-07-13 | Hancock | Maine | 23009 | 18 | 1 |
326250 | 326250 | 2020-07-12 | Hancock | Maine | 23009 | 18 | 1 |
323067 | 323067 | 2020-07-11 | Hancock | Maine | 23009 | 18 | 1 |
319888 | 319888 | 2020-07-10 | Hancock | Maine | 23009 | 18 | 1 |
316713 | 316713 | 2020-07-09 | Hancock | Maine | 23009 | 18 | 1 |
313539 | 313539 | 2020-07-08 | Hancock | Maine | 23009 | 18 | 1 |
310369 | 310369 | 2020-07-07 | Hancock | Maine | 23009 | 18 | 1 |
307201 | 307201 | 2020-07-06 | Hancock | Maine | 23009 | 18 | 1 |
304034 | 304034 | 2020-07-05 | Hancock | Maine | 23009 | 17 | 1 |
300870 | 300870 | 2020-07-04 | Hancock | Maine | 23009 | 17 | 1 |
297708 | 297708 | 2020-07-03 | Hancock | Maine | 23009 | 16 | 1 |
294550 | 294550 | 2020-07-02 | Hancock | Maine | 23009 | 16 | 1 |
291396 | 291396 | 2020-07-01 | Hancock | Maine | 23009 | 16 | 1 |
288245 | 288245 | 2020-06-30 | Hancock | Maine | 23009 | 16 | 1 |
285096 | 285096 | 2020-06-29 | Hancock | Maine | 23009 | 16 | 1 |
281950 | 281950 | 2020-06-28 | Hancock | Maine | 23009 | 16 | 1 |
278802 | 278802 | 2020-06-27 | Hancock | Maine | 23009 | 16 | 1 |
275654 | 275654 | 2020-06-26 | Hancock | Maine | 23009 | 16 | 1 |
272511 | 272511 | 2020-06-25 | Hancock | Maine | 23009 | 15 | 1 |
269375 | 269375 | 2020-06-24 | Hancock | Maine | 23009 | 15 | 1 |
266242 | 266242 | 2020-06-23 | Hancock | Maine | 23009 | 15 | 1 |
263115 | 263115 | 2020-06-22 | Hancock | Maine | 23009 | 15 | 1 |
259986 | 259986 | 2020-06-21 | Hancock | Maine | 23009 | 14 | 1 |
256860 | 256860 | 2020-06-20 | Hancock | Maine | 23009 | 14 | 1 |
253740 | 253740 | 2020-06-19 | Hancock | Maine | 23009 | 13 | 1 |
250625 | 250625 | 2020-06-18 | Hancock | Maine | 23009 | 13 | 1 |
247513 | 247513 | 2020-06-17 | Hancock | Maine | 23009 | 13 | 1 |
244400 | 244400 | 2020-06-16 | Hancock | Maine | 23009 | 13 | 1 |
241289 | 241289 | 2020-06-15 | Hancock | Maine | 23009 | 13 | 1 |
238180 | 238180 | 2020-06-14 | Hancock | Maine | 23009 | 13 | 1 |
235073 | 235073 | 2020-06-13 | Hancock | Maine | 23009 | 13 | 1 |
231968 | 231968 | 2020-06-12 | Hancock | Maine | 23009 | 13 | 1 |
228864 | 228864 | 2020-06-11 | Hancock | Maine | 23009 | 12 | 1 |
225762 | 225762 | 2020-06-10 | Hancock | Maine | 23009 | 12 | 1 |
222666 | 222666 | 2020-06-09 | Hancock | Maine | 23009 | 12 | 1 |
219571 | 219571 | 2020-06-08 | Hancock | Maine | 23009 | 12 | 1 |
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);