ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Broadwater" and state = "Montana" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
279225 | 279225 | 2020-06-27 | Broadwater | Montana | 30007 | 5 | 0 |
282373 | 282373 | 2020-06-28 | Broadwater | Montana | 30007 | 5 | 0 |
285518 | 285518 | 2020-06-29 | Broadwater | Montana | 30007 | 5 | 0 |
288668 | 288668 | 2020-06-30 | Broadwater | Montana | 30007 | 5 | 0 |
291819 | 291819 | 2020-07-01 | Broadwater | Montana | 30007 | 5 | 0 |
294973 | 294973 | 2020-07-02 | Broadwater | Montana | 30007 | 5 | 0 |
298131 | 298131 | 2020-07-03 | Broadwater | Montana | 30007 | 5 | 0 |
301294 | 301294 | 2020-07-04 | Broadwater | Montana | 30007 | 5 | 0 |
304458 | 304458 | 2020-07-05 | Broadwater | Montana | 30007 | 5 | 0 |
307625 | 307625 | 2020-07-06 | Broadwater | Montana | 30007 | 5 | 0 |
310793 | 310793 | 2020-07-07 | Broadwater | Montana | 30007 | 5 | 0 |
313964 | 313964 | 2020-07-08 | Broadwater | Montana | 30007 | 5 | 0 |
317138 | 317138 | 2020-07-09 | Broadwater | Montana | 30007 | 5 | 0 |
320313 | 320313 | 2020-07-10 | Broadwater | Montana | 30007 | 6 | 0 |
323492 | 323492 | 2020-07-11 | Broadwater | Montana | 30007 | 7 | 0 |
326675 | 326675 | 2020-07-12 | Broadwater | Montana | 30007 | 9 | 0 |
329861 | 329861 | 2020-07-13 | Broadwater | Montana | 30007 | 9 | 0 |
333048 | 333048 | 2020-07-14 | Broadwater | Montana | 30007 | 9 | 0 |
336241 | 336241 | 2020-07-15 | Broadwater | Montana | 30007 | 9 | 0 |
339438 | 339438 | 2020-07-16 | Broadwater | Montana | 30007 | 9 | 0 |
342634 | 342634 | 2020-07-17 | Broadwater | Montana | 30007 | 9 | 0 |
345834 | 345834 | 2020-07-18 | Broadwater | Montana | 30007 | 9 | 0 |
349035 | 349035 | 2020-07-19 | Broadwater | Montana | 30007 | 9 | 0 |
352235 | 352235 | 2020-07-20 | Broadwater | Montana | 30007 | 9 | 0 |
355437 | 355437 | 2020-07-21 | Broadwater | Montana | 30007 | 9 | 0 |
358640 | 358640 | 2020-07-22 | Broadwater | Montana | 30007 | 9 | 0 |
361845 | 361845 | 2020-07-23 | Broadwater | Montana | 30007 | 9 | 0 |
365052 | 365052 | 2020-07-24 | Broadwater | Montana | 30007 | 9 | 0 |
368260 | 368260 | 2020-07-25 | Broadwater | Montana | 30007 | 9 | 0 |
371471 | 371471 | 2020-07-26 | Broadwater | Montana | 30007 | 10 | 0 |
374683 | 374683 | 2020-07-27 | Broadwater | Montana | 30007 | 10 | 0 |
377898 | 377898 | 2020-07-28 | Broadwater | Montana | 30007 | 10 | 0 |
381115 | 381115 | 2020-07-29 | Broadwater | Montana | 30007 | 10 | 0 |
384331 | 384331 | 2020-07-30 | Broadwater | Montana | 30007 | 10 | 0 |
387549 | 387549 | 2020-07-31 | Broadwater | Montana | 30007 | 10 | 0 |
390766 | 390766 | 2020-08-01 | Broadwater | Montana | 30007 | 10 | 0 |
393983 | 393983 | 2020-08-02 | Broadwater | Montana | 30007 | 10 | 0 |
397199 | 397199 | 2020-08-03 | Broadwater | Montana | 30007 | 11 | 0 |
400413 | 400413 | 2020-08-04 | Broadwater | Montana | 30007 | 11 | 0 |
403630 | 403630 | 2020-08-05 | Broadwater | Montana | 30007 | 11 | 0 |
406848 | 406848 | 2020-08-06 | Broadwater | Montana | 30007 | 11 | 0 |
410068 | 410068 | 2020-08-07 | Broadwater | Montana | 30007 | 11 | 0 |
413288 | 413288 | 2020-08-08 | Broadwater | Montana | 30007 | 11 | 0 |
416508 | 416508 | 2020-08-09 | Broadwater | Montana | 30007 | 12 | 0 |
419729 | 419729 | 2020-08-10 | Broadwater | Montana | 30007 | 12 | 0 |
422951 | 422951 | 2020-08-11 | Broadwater | Montana | 30007 | 12 | 0 |
426173 | 426173 | 2020-08-12 | Broadwater | Montana | 30007 | 14 | 0 |
429397 | 429397 | 2020-08-13 | Broadwater | Montana | 30007 | 14 | 0 |
432624 | 432624 | 2020-08-14 | Broadwater | Montana | 30007 | 14 | 0 |
435850 | 435850 | 2020-08-15 | Broadwater | Montana | 30007 | 14 | 0 |
439075 | 439075 | 2020-08-16 | Broadwater | Montana | 30007 | 14 | 0 |
442302 | 442302 | 2020-08-17 | Broadwater | Montana | 30007 | 14 | 0 |
445528 | 445528 | 2020-08-18 | Broadwater | Montana | 30007 | 14 | 0 |
448754 | 448754 | 2020-08-19 | Broadwater | Montana | 30007 | 14 | 0 |
451982 | 451982 | 2020-08-20 | Broadwater | Montana | 30007 | 14 | 0 |
455210 | 455210 | 2020-08-21 | Broadwater | Montana | 30007 | 14 | 0 |
458438 | 458438 | 2020-08-22 | Broadwater | Montana | 30007 | 14 | 0 |
461665 | 461665 | 2020-08-23 | Broadwater | Montana | 30007 | 14 | 0 |
464896 | 464896 | 2020-08-24 | Broadwater | Montana | 30007 | 15 | 0 |
468125 | 468125 | 2020-08-25 | Broadwater | Montana | 30007 | 16 | 0 |
471355 | 471355 | 2020-08-26 | Broadwater | Montana | 30007 | 16 | 0 |
474587 | 474587 | 2020-08-27 | Broadwater | Montana | 30007 | 16 | 0 |
477820 | 477820 | 2020-08-28 | Broadwater | Montana | 30007 | 16 | 0 |
481052 | 481052 | 2020-08-29 | Broadwater | Montana | 30007 | 16 | 0 |
484287 | 484287 | 2020-08-30 | Broadwater | Montana | 30007 | 16 | 0 |
487521 | 487521 | 2020-08-31 | Broadwater | Montana | 30007 | 16 | 0 |
490754 | 490754 | 2020-09-01 | Broadwater | Montana | 30007 | 16 | 0 |
493988 | 493988 | 2020-09-02 | Broadwater | Montana | 30007 | 16 | 0 |
497221 | 497221 | 2020-09-03 | Broadwater | Montana | 30007 | 16 | 0 |
500455 | 500455 | 2020-09-04 | Broadwater | Montana | 30007 | 16 | 0 |
503689 | 503689 | 2020-09-05 | Broadwater | Montana | 30007 | 16 | 0 |
506922 | 506922 | 2020-09-06 | Broadwater | Montana | 30007 | 16 | 0 |
510155 | 510155 | 2020-09-07 | Broadwater | Montana | 30007 | 16 | 0 |
513387 | 513387 | 2020-09-08 | Broadwater | Montana | 30007 | 16 | 0 |
516621 | 516621 | 2020-09-09 | Broadwater | Montana | 30007 | 16 | 0 |
519856 | 519856 | 2020-09-10 | Broadwater | Montana | 30007 | 17 | 0 |
523093 | 523093 | 2020-09-11 | Broadwater | Montana | 30007 | 17 | 0 |
526329 | 526329 | 2020-09-12 | Broadwater | Montana | 30007 | 17 | 0 |
529565 | 529565 | 2020-09-13 | Broadwater | Montana | 30007 | 17 | 0 |
532801 | 532801 | 2020-09-14 | Broadwater | Montana | 30007 | 17 | 0 |
536036 | 536036 | 2020-09-15 | Broadwater | Montana | 30007 | 17 | 0 |
539273 | 539273 | 2020-09-16 | Broadwater | Montana | 30007 | 17 | 0 |
542509 | 542509 | 2020-09-17 | Broadwater | Montana | 30007 | 17 | 0 |
545746 | 545746 | 2020-09-18 | Broadwater | Montana | 30007 | 17 | 0 |
548984 | 548984 | 2020-09-19 | Broadwater | Montana | 30007 | 17 | 0 |
552223 | 552223 | 2020-09-20 | Broadwater | Montana | 30007 | 17 | 0 |
555461 | 555461 | 2020-09-21 | Broadwater | Montana | 30007 | 17 | 0 |
558698 | 558698 | 2020-09-22 | Broadwater | Montana | 30007 | 17 | 0 |
561935 | 561935 | 2020-09-23 | Broadwater | Montana | 30007 | 17 | 0 |
565175 | 565175 | 2020-09-24 | Broadwater | Montana | 30007 | 17 | 0 |
568415 | 568415 | 2020-09-25 | Broadwater | Montana | 30007 | 17 | 0 |
571657 | 571657 | 2020-09-26 | Broadwater | Montana | 30007 | 17 | 0 |
574900 | 574900 | 2020-09-27 | Broadwater | Montana | 30007 | 17 | 0 |
578141 | 578141 | 2020-09-28 | Broadwater | Montana | 30007 | 17 | 0 |
581382 | 581382 | 2020-09-29 | Broadwater | Montana | 30007 | 18 | 0 |
584623 | 584623 | 2020-09-30 | Broadwater | Montana | 30007 | 18 | 0 |
587863 | 587863 | 2020-10-01 | Broadwater | Montana | 30007 | 18 | 0 |
591104 | 591104 | 2020-10-02 | Broadwater | Montana | 30007 | 18 | 0 |
594345 | 594345 | 2020-10-03 | Broadwater | Montana | 30007 | 18 | 0 |
597586 | 597586 | 2020-10-04 | Broadwater | Montana | 30007 | 18 | 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);