ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,564 rows where county = "Roosevelt" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4816 | 4816 | 2020-03-19 | Roosevelt | Montana | 30085 | 1 | 0 |
5655 | 5655 | 2020-03-20 | Roosevelt | Montana | 30085 | 1 | 0 |
6647 | 6647 | 2020-03-21 | Roosevelt | Montana | 30085 | 1 | 0 |
7736 | 7736 | 2020-03-22 | Roosevelt | Montana | 30085 | 1 | 0 |
8929 | 8929 | 2020-03-23 | Roosevelt | Montana | 30085 | 1 | 0 |
10232 | 10232 | 2020-03-24 | Roosevelt | Montana | 30085 | 1 | 0 |
11662 | 11662 | 2020-03-25 | Roosevelt | Montana | 30085 | 1 | 0 |
13262 | 13262 | 2020-03-26 | Roosevelt | Montana | 30085 | 1 | 0 |
14994 | 14994 | 2020-03-27 | Roosevelt | Montana | 30085 | 1 | 0 |
15062 | 15062 | 2020-03-27 | Roosevelt | New Mexico | 35041 | 1 | 0 |
16820 | 16820 | 2020-03-28 | Roosevelt | Montana | 30085 | 1 | 0 |
16891 | 16891 | 2020-03-28 | Roosevelt | New Mexico | 35041 | 1 | 0 |
18743 | 18743 | 2020-03-29 | Roosevelt | Montana | 30085 | 1 | 0 |
18815 | 18815 | 2020-03-29 | Roosevelt | New Mexico | 35041 | 1 | 0 |
20778 | 20778 | 2020-03-30 | Roosevelt | Montana | 30085 | 1 | 0 |
20853 | 20853 | 2020-03-30 | Roosevelt | New Mexico | 35041 | 1 | 0 |
22900 | 22900 | 2020-03-31 | Roosevelt | Montana | 30085 | 1 | 0 |
22976 | 22976 | 2020-03-31 | Roosevelt | New Mexico | 35041 | 1 | 0 |
25089 | 25089 | 2020-04-01 | Roosevelt | Montana | 30085 | 1 | 0 |
25170 | 25170 | 2020-04-01 | Roosevelt | New Mexico | 35041 | 1 | 0 |
27346 | 27346 | 2020-04-02 | Roosevelt | Montana | 30085 | 1 | 0 |
27430 | 27430 | 2020-04-02 | Roosevelt | New Mexico | 35041 | 1 | 0 |
29669 | 29669 | 2020-04-03 | Roosevelt | Montana | 30085 | 1 | 0 |
29753 | 29753 | 2020-04-03 | Roosevelt | New Mexico | 35041 | 1 | 0 |
32051 | 32051 | 2020-04-04 | Roosevelt | Montana | 30085 | 1 | 0 |
32140 | 32140 | 2020-04-04 | Roosevelt | New Mexico | 35041 | 1 | 0 |
34479 | 34479 | 2020-04-05 | Roosevelt | Montana | 30085 | 1 | 0 |
34571 | 34571 | 2020-04-05 | Roosevelt | New Mexico | 35041 | 1 | 0 |
36946 | 36946 | 2020-04-06 | Roosevelt | Montana | 30085 | 1 | 0 |
37041 | 37041 | 2020-04-06 | Roosevelt | New Mexico | 35041 | 1 | 0 |
39462 | 39462 | 2020-04-07 | Roosevelt | Montana | 30085 | 1 | 0 |
39556 | 39556 | 2020-04-07 | Roosevelt | New Mexico | 35041 | 1 | 0 |
42018 | 42018 | 2020-04-08 | Roosevelt | Montana | 30085 | 2 | 0 |
42113 | 42113 | 2020-04-08 | Roosevelt | New Mexico | 35041 | 1 | 0 |
44597 | 44597 | 2020-04-09 | Roosevelt | Montana | 30085 | 2 | 0 |
44696 | 44696 | 2020-04-09 | Roosevelt | New Mexico | 35041 | 1 | 0 |
47207 | 47207 | 2020-04-10 | Roosevelt | Montana | 30085 | 2 | 0 |
47309 | 47309 | 2020-04-10 | Roosevelt | New Mexico | 35041 | 1 | 0 |
49856 | 49856 | 2020-04-11 | Roosevelt | Montana | 30085 | 3 | 0 |
49964 | 49964 | 2020-04-11 | Roosevelt | New Mexico | 35041 | 1 | 0 |
52529 | 52529 | 2020-04-12 | Roosevelt | Montana | 30085 | 3 | 0 |
52637 | 52637 | 2020-04-12 | Roosevelt | New Mexico | 35041 | 1 | 0 |
55210 | 55210 | 2020-04-13 | Roosevelt | Montana | 30085 | 3 | 0 |
55320 | 55320 | 2020-04-13 | Roosevelt | New Mexico | 35041 | 1 | 0 |
57909 | 57909 | 2020-04-14 | Roosevelt | Montana | 30085 | 3 | 0 |
58020 | 58020 | 2020-04-14 | Roosevelt | New Mexico | 35041 | 1 | 0 |
60623 | 60623 | 2020-04-15 | Roosevelt | Montana | 30085 | 4 | 0 |
60734 | 60734 | 2020-04-15 | Roosevelt | New Mexico | 35041 | 1 | 0 |
63346 | 63346 | 2020-04-16 | Roosevelt | Montana | 30085 | 4 | 0 |
63460 | 63460 | 2020-04-16 | Roosevelt | New Mexico | 35041 | 1 | 0 |
66086 | 66086 | 2020-04-17 | Roosevelt | Montana | 30085 | 6 | 0 |
66202 | 66202 | 2020-04-17 | Roosevelt | New Mexico | 35041 | 1 | 0 |
68840 | 68840 | 2020-04-18 | Roosevelt | Montana | 30085 | 6 | 0 |
68959 | 68959 | 2020-04-18 | Roosevelt | New Mexico | 35041 | 1 | 0 |
71607 | 71607 | 2020-04-19 | Roosevelt | Montana | 30085 | 6 | 0 |
71726 | 71726 | 2020-04-19 | Roosevelt | New Mexico | 35041 | 1 | 0 |
74380 | 74380 | 2020-04-20 | Roosevelt | Montana | 30085 | 6 | 0 |
74501 | 74501 | 2020-04-20 | Roosevelt | New Mexico | 35041 | 1 | 0 |
77160 | 77160 | 2020-04-21 | Roosevelt | Montana | 30085 | 7 | 0 |
77282 | 77282 | 2020-04-21 | Roosevelt | New Mexico | 35041 | 1 | 0 |
79948 | 79948 | 2020-04-22 | Roosevelt | Montana | 30085 | 7 | 0 |
80071 | 80071 | 2020-04-22 | Roosevelt | New Mexico | 35041 | 4 | 0 |
82744 | 82744 | 2020-04-23 | Roosevelt | Montana | 30085 | 7 | 0 |
82870 | 82870 | 2020-04-23 | Roosevelt | New Mexico | 35041 | 4 | 0 |
85548 | 85548 | 2020-04-24 | Roosevelt | Montana | 30085 | 7 | 0 |
85674 | 85674 | 2020-04-24 | Roosevelt | New Mexico | 35041 | 4 | 0 |
88358 | 88358 | 2020-04-25 | Roosevelt | Montana | 30085 | 7 | 0 |
88485 | 88485 | 2020-04-25 | Roosevelt | New Mexico | 35041 | 6 | 0 |
91173 | 91173 | 2020-04-26 | Roosevelt | Montana | 30085 | 7 | 0 |
91300 | 91300 | 2020-04-26 | Roosevelt | New Mexico | 35041 | 7 | 0 |
93994 | 93994 | 2020-04-27 | Roosevelt | Montana | 30085 | 7 | 0 |
94124 | 94124 | 2020-04-27 | Roosevelt | New Mexico | 35041 | 7 | 0 |
96830 | 96830 | 2020-04-28 | Roosevelt | Montana | 30085 | 7 | 0 |
96960 | 96960 | 2020-04-28 | Roosevelt | New Mexico | 35041 | 8 | 0 |
99676 | 99676 | 2020-04-29 | Roosevelt | Montana | 30085 | 7 | 0 |
99807 | 99807 | 2020-04-29 | Roosevelt | New Mexico | 35041 | 8 | 0 |
102528 | 102528 | 2020-04-30 | Roosevelt | Montana | 30085 | 7 | 0 |
102660 | 102660 | 2020-04-30 | Roosevelt | New Mexico | 35041 | 9 | 0 |
105389 | 105389 | 2020-05-01 | Roosevelt | Montana | 30085 | 7 | 0 |
105522 | 105522 | 2020-05-01 | Roosevelt | New Mexico | 35041 | 9 | 0 |
108255 | 108255 | 2020-05-02 | Roosevelt | Montana | 30085 | 7 | 0 |
108388 | 108388 | 2020-05-02 | Roosevelt | New Mexico | 35041 | 9 | 0 |
111127 | 111127 | 2020-05-03 | Roosevelt | Montana | 30085 | 7 | 0 |
111261 | 111261 | 2020-05-03 | Roosevelt | New Mexico | 35041 | 10 | 0 |
114006 | 114006 | 2020-05-04 | Roosevelt | Montana | 30085 | 7 | 0 |
114142 | 114142 | 2020-05-04 | Roosevelt | New Mexico | 35041 | 10 | 0 |
116888 | 116888 | 2020-05-05 | Roosevelt | Montana | 30085 | 7 | 0 |
117023 | 117023 | 2020-05-05 | Roosevelt | New Mexico | 35041 | 10 | 0 |
119848 | 119848 | 2020-05-06 | Roosevelt | Montana | 30085 | 7 | 0 |
119984 | 119984 | 2020-05-06 | Roosevelt | New Mexico | 35041 | 11 | 0 |
122822 | 122822 | 2020-05-07 | Roosevelt | Montana | 30085 | 7 | 0 |
122959 | 122959 | 2020-05-07 | Roosevelt | New Mexico | 35041 | 11 | 0 |
125804 | 125804 | 2020-05-08 | Roosevelt | Montana | 30085 | 7 | 0 |
125942 | 125942 | 2020-05-08 | Roosevelt | New Mexico | 35041 | 11 | 0 |
128792 | 128792 | 2020-05-09 | Roosevelt | Montana | 30085 | 7 | 0 |
128931 | 128931 | 2020-05-09 | Roosevelt | New Mexico | 35041 | 11 | 0 |
131782 | 131782 | 2020-05-10 | Roosevelt | Montana | 30085 | 7 | 0 |
131920 | 131920 | 2020-05-10 | Roosevelt | New Mexico | 35041 | 11 | 0 |
134773 | 134773 | 2020-05-11 | Roosevelt | Montana | 30085 | 7 | 0 |
134911 | 134911 | 2020-05-11 | Roosevelt | New Mexico | 35041 | 11 | 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);