ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where fips = 23029 and state = "Maine" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535620 | 535620 | 2020-09-15 | Washington | Maine | 23029 | 15 | 0 |
532385 | 532385 | 2020-09-14 | Washington | Maine | 23029 | 15 | 0 |
529149 | 529149 | 2020-09-13 | Washington | Maine | 23029 | 15 | 0 |
525913 | 525913 | 2020-09-12 | Washington | Maine | 23029 | 15 | 0 |
522677 | 522677 | 2020-09-11 | Washington | Maine | 23029 | 15 | 0 |
519440 | 519440 | 2020-09-10 | Washington | Maine | 23029 | 15 | 0 |
516205 | 516205 | 2020-09-09 | Washington | Maine | 23029 | 15 | 0 |
512971 | 512971 | 2020-09-08 | Washington | Maine | 23029 | 15 | 0 |
509739 | 509739 | 2020-09-07 | Washington | Maine | 23029 | 15 | 0 |
506506 | 506506 | 2020-09-06 | Washington | Maine | 23029 | 15 | 0 |
503273 | 503273 | 2020-09-05 | Washington | Maine | 23029 | 15 | 0 |
500039 | 500039 | 2020-09-04 | Washington | Maine | 23029 | 15 | 0 |
496805 | 496805 | 2020-09-03 | Washington | Maine | 23029 | 15 | 0 |
493572 | 493572 | 2020-09-02 | Washington | Maine | 23029 | 15 | 0 |
490338 | 490338 | 2020-09-01 | Washington | Maine | 23029 | 15 | 0 |
487105 | 487105 | 2020-08-31 | Washington | Maine | 23029 | 15 | 0 |
483871 | 483871 | 2020-08-30 | Washington | Maine | 23029 | 15 | 0 |
480636 | 480636 | 2020-08-29 | Washington | Maine | 23029 | 15 | 0 |
477404 | 477404 | 2020-08-28 | Washington | Maine | 23029 | 15 | 0 |
474171 | 474171 | 2020-08-27 | Washington | Maine | 23029 | 15 | 0 |
470939 | 470939 | 2020-08-26 | Washington | Maine | 23029 | 15 | 0 |
467709 | 467709 | 2020-08-25 | Washington | Maine | 23029 | 15 | 0 |
464480 | 464480 | 2020-08-24 | Washington | Maine | 23029 | 15 | 0 |
461249 | 461249 | 2020-08-23 | Washington | Maine | 23029 | 15 | 0 |
458022 | 458022 | 2020-08-22 | Washington | Maine | 23029 | 15 | 0 |
454794 | 454794 | 2020-08-21 | Washington | Maine | 23029 | 15 | 0 |
451566 | 451566 | 2020-08-20 | Washington | Maine | 23029 | 15 | 0 |
448338 | 448338 | 2020-08-19 | Washington | Maine | 23029 | 15 | 0 |
445112 | 445112 | 2020-08-18 | Washington | Maine | 23029 | 15 | 0 |
441886 | 441886 | 2020-08-17 | Washington | Maine | 23029 | 15 | 0 |
438659 | 438659 | 2020-08-16 | Washington | Maine | 23029 | 14 | 0 |
435434 | 435434 | 2020-08-15 | Washington | Maine | 23029 | 14 | 0 |
432208 | 432208 | 2020-08-14 | Washington | Maine | 23029 | 14 | 0 |
428981 | 428981 | 2020-08-13 | Washington | Maine | 23029 | 13 | 0 |
425757 | 425757 | 2020-08-12 | Washington | Maine | 23029 | 13 | 0 |
422535 | 422535 | 2020-08-11 | Washington | Maine | 23029 | 13 | 0 |
419313 | 419313 | 2020-08-10 | Washington | Maine | 23029 | 13 | 0 |
416092 | 416092 | 2020-08-09 | Washington | Maine | 23029 | 13 | 0 |
412872 | 412872 | 2020-08-08 | Washington | Maine | 23029 | 12 | 0 |
409652 | 409652 | 2020-08-07 | Washington | Maine | 23029 | 12 | 0 |
406432 | 406432 | 2020-08-06 | Washington | Maine | 23029 | 12 | 0 |
403214 | 403214 | 2020-08-05 | Washington | Maine | 23029 | 12 | 0 |
399997 | 399997 | 2020-08-04 | Washington | Maine | 23029 | 12 | 0 |
396783 | 396783 | 2020-08-03 | Washington | Maine | 23029 | 9 | 0 |
393567 | 393567 | 2020-08-02 | Washington | Maine | 23029 | 9 | 0 |
390350 | 390350 | 2020-08-01 | Washington | Maine | 23029 | 8 | 0 |
387133 | 387133 | 2020-07-31 | Washington | Maine | 23029 | 7 | 0 |
383915 | 383915 | 2020-07-30 | Washington | Maine | 23029 | 7 | 0 |
380698 | 380698 | 2020-07-29 | Washington | Maine | 23029 | 7 | 0 |
377481 | 377481 | 2020-07-28 | Washington | Maine | 23029 | 7 | 0 |
374266 | 374266 | 2020-07-27 | Washington | Maine | 23029 | 7 | 0 |
371054 | 371054 | 2020-07-26 | Washington | Maine | 23029 | 7 | 0 |
367844 | 367844 | 2020-07-25 | Washington | Maine | 23029 | 5 | 0 |
364637 | 364637 | 2020-07-24 | Washington | Maine | 23029 | 5 | 0 |
361430 | 361430 | 2020-07-23 | Washington | Maine | 23029 | 6 | 0 |
358225 | 358225 | 2020-07-22 | Washington | Maine | 23029 | 6 | 0 |
355022 | 355022 | 2020-07-21 | Washington | Maine | 23029 | 6 | 0 |
351820 | 351820 | 2020-07-20 | Washington | Maine | 23029 | 6 | 0 |
348620 | 348620 | 2020-07-19 | Washington | Maine | 23029 | 6 | 0 |
345419 | 345419 | 2020-07-18 | Washington | Maine | 23029 | 5 | 0 |
342219 | 342219 | 2020-07-17 | Washington | Maine | 23029 | 5 | 0 |
339023 | 339023 | 2020-07-16 | Washington | Maine | 23029 | 5 | 0 |
335827 | 335827 | 2020-07-15 | Washington | Maine | 23029 | 5 | 0 |
332634 | 332634 | 2020-07-14 | Washington | Maine | 23029 | 4 | 0 |
329447 | 329447 | 2020-07-13 | Washington | Maine | 23029 | 5 | 0 |
326261 | 326261 | 2020-07-12 | Washington | Maine | 23029 | 5 | 0 |
323078 | 323078 | 2020-07-11 | Washington | Maine | 23029 | 5 | 0 |
319899 | 319899 | 2020-07-10 | Washington | Maine | 23029 | 5 | 0 |
316724 | 316724 | 2020-07-09 | Washington | Maine | 23029 | 5 | 0 |
313550 | 313550 | 2020-07-08 | Washington | Maine | 23029 | 5 | 0 |
310380 | 310380 | 2020-07-07 | Washington | Maine | 23029 | 4 | 0 |
307212 | 307212 | 2020-07-06 | Washington | Maine | 23029 | 3 | 0 |
304045 | 304045 | 2020-07-05 | Washington | Maine | 23029 | 3 | 0 |
300881 | 300881 | 2020-07-04 | Washington | Maine | 23029 | 3 | 0 |
297719 | 297719 | 2020-07-03 | Washington | Maine | 23029 | 3 | 0 |
294561 | 294561 | 2020-07-02 | Washington | Maine | 23029 | 3 | 0 |
291407 | 291407 | 2020-07-01 | Washington | Maine | 23029 | 3 | 0 |
288256 | 288256 | 2020-06-30 | Washington | Maine | 23029 | 2 | 0 |
285106 | 285106 | 2020-06-29 | Washington | Maine | 23029 | 2 | 0 |
281961 | 281961 | 2020-06-28 | Washington | Maine | 23029 | 2 | 0 |
278813 | 278813 | 2020-06-27 | Washington | Maine | 23029 | 2 | 0 |
275665 | 275665 | 2020-06-26 | Washington | Maine | 23029 | 2 | 0 |
272522 | 272522 | 2020-06-25 | Washington | Maine | 23029 | 2 | 0 |
269385 | 269385 | 2020-06-24 | Washington | Maine | 23029 | 2 | 0 |
266252 | 266252 | 2020-06-23 | Washington | Maine | 23029 | 2 | 0 |
263126 | 263126 | 2020-06-22 | Washington | Maine | 23029 | 2 | 0 |
259997 | 259997 | 2020-06-21 | Washington | Maine | 23029 | 2 | 0 |
256871 | 256871 | 2020-06-20 | Washington | Maine | 23029 | 2 | 0 |
253751 | 253751 | 2020-06-19 | Washington | Maine | 23029 | 2 | 0 |
250636 | 250636 | 2020-06-18 | Washington | Maine | 23029 | 2 | 0 |
247524 | 247524 | 2020-06-17 | Washington | Maine | 23029 | 1 | 0 |
244411 | 244411 | 2020-06-16 | Washington | Maine | 23029 | 1 | 0 |
241300 | 241300 | 2020-06-15 | Washington | Maine | 23029 | 1 | 0 |
238191 | 238191 | 2020-06-14 | Washington | Maine | 23029 | 1 | 0 |
235084 | 235084 | 2020-06-13 | Washington | Maine | 23029 | 1 | 0 |
231979 | 231979 | 2020-06-12 | Washington | Maine | 23029 | 1 | 0 |
228875 | 228875 | 2020-06-11 | Washington | Maine | 23029 | 1 | 0 |
225773 | 225773 | 2020-06-10 | Washington | Maine | 23029 | 1 | 0 |
222677 | 222677 | 2020-06-09 | Washington | Maine | 23029 | 1 | 0 |
219582 | 219582 | 2020-06-08 | Washington | Maine | 23029 | 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);