ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
167 rows where county = "Meagher", deaths = 0 and state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
513412 | 513412 | 2020-09-08 | Meagher | Montana | 30059 | 9 | 0 |
510180 | 510180 | 2020-09-07 | Meagher | Montana | 30059 | 9 | 0 |
506947 | 506947 | 2020-09-06 | Meagher | Montana | 30059 | 4 | 0 |
503714 | 503714 | 2020-09-05 | Meagher | Montana | 30059 | 4 | 0 |
500480 | 500480 | 2020-09-04 | Meagher | Montana | 30059 | 4 | 0 |
497246 | 497246 | 2020-09-03 | Meagher | Montana | 30059 | 4 | 0 |
494013 | 494013 | 2020-09-02 | Meagher | Montana | 30059 | 4 | 0 |
490779 | 490779 | 2020-09-01 | Meagher | Montana | 30059 | 4 | 0 |
487546 | 487546 | 2020-08-31 | Meagher | Montana | 30059 | 4 | 0 |
484312 | 484312 | 2020-08-30 | Meagher | Montana | 30059 | 4 | 0 |
481077 | 481077 | 2020-08-29 | Meagher | Montana | 30059 | 4 | 0 |
477845 | 477845 | 2020-08-28 | Meagher | Montana | 30059 | 4 | 0 |
474612 | 474612 | 2020-08-27 | Meagher | Montana | 30059 | 4 | 0 |
471380 | 471380 | 2020-08-26 | Meagher | Montana | 30059 | 4 | 0 |
468150 | 468150 | 2020-08-25 | Meagher | Montana | 30059 | 4 | 0 |
464921 | 464921 | 2020-08-24 | Meagher | Montana | 30059 | 4 | 0 |
461690 | 461690 | 2020-08-23 | Meagher | Montana | 30059 | 4 | 0 |
458463 | 458463 | 2020-08-22 | Meagher | Montana | 30059 | 4 | 0 |
455235 | 455235 | 2020-08-21 | Meagher | Montana | 30059 | 4 | 0 |
452007 | 452007 | 2020-08-20 | Meagher | Montana | 30059 | 4 | 0 |
448779 | 448779 | 2020-08-19 | Meagher | Montana | 30059 | 4 | 0 |
445553 | 445553 | 2020-08-18 | Meagher | Montana | 30059 | 4 | 0 |
442327 | 442327 | 2020-08-17 | Meagher | Montana | 30059 | 4 | 0 |
439100 | 439100 | 2020-08-16 | Meagher | Montana | 30059 | 4 | 0 |
435875 | 435875 | 2020-08-15 | Meagher | Montana | 30059 | 4 | 0 |
432649 | 432649 | 2020-08-14 | Meagher | Montana | 30059 | 4 | 0 |
429422 | 429422 | 2020-08-13 | Meagher | Montana | 30059 | 4 | 0 |
426198 | 426198 | 2020-08-12 | Meagher | Montana | 30059 | 4 | 0 |
422976 | 422976 | 2020-08-11 | Meagher | Montana | 30059 | 4 | 0 |
419754 | 419754 | 2020-08-10 | Meagher | Montana | 30059 | 4 | 0 |
416533 | 416533 | 2020-08-09 | Meagher | Montana | 30059 | 4 | 0 |
413313 | 413313 | 2020-08-08 | Meagher | Montana | 30059 | 4 | 0 |
410093 | 410093 | 2020-08-07 | Meagher | Montana | 30059 | 4 | 0 |
406873 | 406873 | 2020-08-06 | Meagher | Montana | 30059 | 4 | 0 |
403655 | 403655 | 2020-08-05 | Meagher | Montana | 30059 | 4 | 0 |
400438 | 400438 | 2020-08-04 | Meagher | Montana | 30059 | 4 | 0 |
397224 | 397224 | 2020-08-03 | Meagher | Montana | 30059 | 4 | 0 |
394008 | 394008 | 2020-08-02 | Meagher | Montana | 30059 | 4 | 0 |
390791 | 390791 | 2020-08-01 | Meagher | Montana | 30059 | 4 | 0 |
387574 | 387574 | 2020-07-31 | Meagher | Montana | 30059 | 4 | 0 |
384356 | 384356 | 2020-07-30 | Meagher | Montana | 30059 | 4 | 0 |
381140 | 381140 | 2020-07-29 | Meagher | Montana | 30059 | 4 | 0 |
377923 | 377923 | 2020-07-28 | Meagher | Montana | 30059 | 4 | 0 |
374708 | 374708 | 2020-07-27 | Meagher | Montana | 30059 | 4 | 0 |
371496 | 371496 | 2020-07-26 | Meagher | Montana | 30059 | 4 | 0 |
368285 | 368285 | 2020-07-25 | Meagher | Montana | 30059 | 4 | 0 |
365076 | 365076 | 2020-07-24 | Meagher | Montana | 30059 | 4 | 0 |
361869 | 361869 | 2020-07-23 | Meagher | Montana | 30059 | 4 | 0 |
358664 | 358664 | 2020-07-22 | Meagher | Montana | 30059 | 4 | 0 |
355460 | 355460 | 2020-07-21 | Meagher | Montana | 30059 | 4 | 0 |
352257 | 352257 | 2020-07-20 | Meagher | Montana | 30059 | 4 | 0 |
349056 | 349056 | 2020-07-19 | Meagher | Montana | 30059 | 4 | 0 |
345855 | 345855 | 2020-07-18 | Meagher | Montana | 30059 | 4 | 0 |
342655 | 342655 | 2020-07-17 | Meagher | Montana | 30059 | 4 | 0 |
339459 | 339459 | 2020-07-16 | Meagher | Montana | 30059 | 4 | 0 |
336262 | 336262 | 2020-07-15 | Meagher | Montana | 30059 | 4 | 0 |
333069 | 333069 | 2020-07-14 | Meagher | Montana | 30059 | 4 | 0 |
329882 | 329882 | 2020-07-13 | Meagher | Montana | 30059 | 4 | 0 |
326695 | 326695 | 2020-07-12 | Meagher | Montana | 30059 | 4 | 0 |
323511 | 323511 | 2020-07-11 | Meagher | Montana | 30059 | 4 | 0 |
320332 | 320332 | 2020-07-10 | Meagher | Montana | 30059 | 4 | 0 |
317157 | 317157 | 2020-07-09 | Meagher | Montana | 30059 | 4 | 0 |
313983 | 313983 | 2020-07-08 | Meagher | Montana | 30059 | 4 | 0 |
310812 | 310812 | 2020-07-07 | Meagher | Montana | 30059 | 2 | 0 |
307644 | 307644 | 2020-07-06 | Meagher | Montana | 30059 | 2 | 0 |
304477 | 304477 | 2020-07-05 | Meagher | Montana | 30059 | 2 | 0 |
301313 | 301313 | 2020-07-04 | Meagher | Montana | 30059 | 2 | 0 |
298150 | 298150 | 2020-07-03 | Meagher | Montana | 30059 | 2 | 0 |
294992 | 294992 | 2020-07-02 | Meagher | Montana | 30059 | 2 | 0 |
291838 | 291838 | 2020-07-01 | Meagher | Montana | 30059 | 2 | 0 |
288687 | 288687 | 2020-06-30 | Meagher | Montana | 30059 | 2 | 0 |
285537 | 285537 | 2020-06-29 | Meagher | Montana | 30059 | 1 | 0 |
282392 | 282392 | 2020-06-28 | Meagher | Montana | 30059 | 1 | 0 |
279244 | 279244 | 2020-06-27 | Meagher | Montana | 30059 | 1 | 0 |
276096 | 276096 | 2020-06-26 | Meagher | Montana | 30059 | 1 | 0 |
272953 | 272953 | 2020-06-25 | Meagher | Montana | 30059 | 1 | 0 |
269814 | 269814 | 2020-06-24 | Meagher | Montana | 30059 | 1 | 0 |
266681 | 266681 | 2020-06-23 | Meagher | Montana | 30059 | 1 | 0 |
263555 | 263555 | 2020-06-22 | Meagher | Montana | 30059 | 1 | 0 |
260426 | 260426 | 2020-06-21 | Meagher | Montana | 30059 | 1 | 0 |
257300 | 257300 | 2020-06-20 | Meagher | Montana | 30059 | 1 | 0 |
254177 | 254177 | 2020-06-19 | Meagher | Montana | 30059 | 1 | 0 |
251062 | 251062 | 2020-06-18 | Meagher | Montana | 30059 | 1 | 0 |
247948 | 247948 | 2020-06-17 | Meagher | Montana | 30059 | 1 | 0 |
244835 | 244835 | 2020-06-16 | Meagher | Montana | 30059 | 1 | 0 |
241724 | 241724 | 2020-06-15 | Meagher | Montana | 30059 | 1 | 0 |
238614 | 238614 | 2020-06-14 | Meagher | Montana | 30059 | 1 | 0 |
235507 | 235507 | 2020-06-13 | Meagher | Montana | 30059 | 1 | 0 |
232401 | 232401 | 2020-06-12 | Meagher | Montana | 30059 | 1 | 0 |
229296 | 229296 | 2020-06-11 | Meagher | Montana | 30059 | 1 | 0 |
226193 | 226193 | 2020-06-10 | Meagher | Montana | 30059 | 1 | 0 |
223094 | 223094 | 2020-06-09 | Meagher | Montana | 30059 | 1 | 0 |
219999 | 219999 | 2020-06-08 | Meagher | Montana | 30059 | 1 | 0 |
216907 | 216907 | 2020-06-07 | Meagher | Montana | 30059 | 1 | 0 |
213818 | 213818 | 2020-06-06 | Meagher | Montana | 30059 | 1 | 0 |
210734 | 210734 | 2020-06-05 | Meagher | Montana | 30059 | 1 | 0 |
207653 | 207653 | 2020-06-04 | Meagher | Montana | 30059 | 1 | 0 |
204572 | 204572 | 2020-06-03 | Meagher | Montana | 30059 | 1 | 0 |
201495 | 201495 | 2020-06-02 | Meagher | Montana | 30059 | 1 | 0 |
198422 | 198422 | 2020-06-01 | Meagher | Montana | 30059 | 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);