ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
766 rows where county = "Richland" and state = "Montana" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
42017 | 42017 | 2020-04-08 | Richland | Montana | 30083 | 2 | 0 |
44596 | 44596 | 2020-04-09 | Richland | Montana | 30083 | 2 | 0 |
47206 | 47206 | 2020-04-10 | Richland | Montana | 30083 | 2 | 0 |
49855 | 49855 | 2020-04-11 | Richland | Montana | 30083 | 3 | 0 |
52528 | 52528 | 2020-04-12 | Richland | Montana | 30083 | 3 | 0 |
55209 | 55209 | 2020-04-13 | Richland | Montana | 30083 | 3 | 0 |
57908 | 57908 | 2020-04-14 | Richland | Montana | 30083 | 3 | 0 |
60622 | 60622 | 2020-04-15 | Richland | Montana | 30083 | 3 | 0 |
63345 | 63345 | 2020-04-16 | Richland | Montana | 30083 | 3 | 0 |
66085 | 66085 | 2020-04-17 | Richland | Montana | 30083 | 3 | 0 |
68839 | 68839 | 2020-04-18 | Richland | Montana | 30083 | 3 | 0 |
71606 | 71606 | 2020-04-19 | Richland | Montana | 30083 | 3 | 0 |
74379 | 74379 | 2020-04-20 | Richland | Montana | 30083 | 3 | 0 |
77159 | 77159 | 2020-04-21 | Richland | Montana | 30083 | 3 | 0 |
79947 | 79947 | 2020-04-22 | Richland | Montana | 30083 | 3 | 0 |
82743 | 82743 | 2020-04-23 | Richland | Montana | 30083 | 3 | 0 |
85547 | 85547 | 2020-04-24 | Richland | Montana | 30083 | 3 | 0 |
88357 | 88357 | 2020-04-25 | Richland | Montana | 30083 | 3 | 0 |
91172 | 91172 | 2020-04-26 | Richland | Montana | 30083 | 3 | 0 |
93993 | 93993 | 2020-04-27 | Richland | Montana | 30083 | 3 | 0 |
96829 | 96829 | 2020-04-28 | Richland | Montana | 30083 | 3 | 0 |
99675 | 99675 | 2020-04-29 | Richland | Montana | 30083 | 3 | 0 |
102527 | 102527 | 2020-04-30 | Richland | Montana | 30083 | 3 | 0 |
105388 | 105388 | 2020-05-01 | Richland | Montana | 30083 | 3 | 0 |
108254 | 108254 | 2020-05-02 | Richland | Montana | 30083 | 3 | 0 |
111126 | 111126 | 2020-05-03 | Richland | Montana | 30083 | 3 | 0 |
114005 | 114005 | 2020-05-04 | Richland | Montana | 30083 | 3 | 0 |
116887 | 116887 | 2020-05-05 | Richland | Montana | 30083 | 3 | 0 |
119847 | 119847 | 2020-05-06 | Richland | Montana | 30083 | 3 | 0 |
122821 | 122821 | 2020-05-07 | Richland | Montana | 30083 | 3 | 0 |
125803 | 125803 | 2020-05-08 | Richland | Montana | 30083 | 3 | 0 |
128791 | 128791 | 2020-05-09 | Richland | Montana | 30083 | 3 | 0 |
131781 | 131781 | 2020-05-10 | Richland | Montana | 30083 | 3 | 0 |
134772 | 134772 | 2020-05-11 | Richland | Montana | 30083 | 3 | 0 |
137762 | 137762 | 2020-05-12 | Richland | Montana | 30083 | 3 | 0 |
140756 | 140756 | 2020-05-13 | Richland | Montana | 30083 | 3 | 0 |
143751 | 143751 | 2020-05-14 | Richland | Montana | 30083 | 3 | 0 |
146752 | 146752 | 2020-05-15 | Richland | Montana | 30083 | 3 | 0 |
149758 | 149758 | 2020-05-16 | Richland | Montana | 30083 | 3 | 0 |
152769 | 152769 | 2020-05-17 | Richland | Montana | 30083 | 3 | 0 |
155783 | 155783 | 2020-05-18 | Richland | Montana | 30083 | 3 | 0 |
158801 | 158801 | 2020-05-19 | Richland | Montana | 30083 | 3 | 0 |
161827 | 161827 | 2020-05-20 | Richland | Montana | 30083 | 3 | 0 |
164856 | 164856 | 2020-05-21 | Richland | Montana | 30083 | 3 | 0 |
167892 | 167892 | 2020-05-22 | Richland | Montana | 30083 | 3 | 0 |
170931 | 170931 | 2020-05-23 | Richland | Montana | 30083 | 3 | 0 |
173973 | 173973 | 2020-05-24 | Richland | Montana | 30083 | 3 | 0 |
177016 | 177016 | 2020-05-25 | Richland | Montana | 30083 | 3 | 0 |
180060 | 180060 | 2020-05-26 | Richland | Montana | 30083 | 3 | 0 |
183108 | 183108 | 2020-05-27 | Richland | Montana | 30083 | 3 | 0 |
186164 | 186164 | 2020-05-28 | Richland | Montana | 30083 | 3 | 0 |
189223 | 189223 | 2020-05-29 | Richland | Montana | 30083 | 3 | 0 |
192287 | 192287 | 2020-05-30 | Richland | Montana | 30083 | 3 | 0 |
195357 | 195357 | 2020-05-31 | Richland | Montana | 30083 | 3 | 0 |
198428 | 198428 | 2020-06-01 | Richland | Montana | 30083 | 3 | 0 |
201501 | 201501 | 2020-06-02 | Richland | Montana | 30083 | 3 | 0 |
204578 | 204578 | 2020-06-03 | Richland | Montana | 30083 | 3 | 0 |
207659 | 207659 | 2020-06-04 | Richland | Montana | 30083 | 3 | 0 |
210740 | 210740 | 2020-06-05 | Richland | Montana | 30083 | 3 | 0 |
213824 | 213824 | 2020-06-06 | Richland | Montana | 30083 | 3 | 0 |
216913 | 216913 | 2020-06-07 | Richland | Montana | 30083 | 3 | 0 |
220005 | 220005 | 2020-06-08 | Richland | Montana | 30083 | 3 | 0 |
223100 | 223100 | 2020-06-09 | Richland | Montana | 30083 | 3 | 0 |
226199 | 226199 | 2020-06-10 | Richland | Montana | 30083 | 3 | 0 |
229302 | 229302 | 2020-06-11 | Richland | Montana | 30083 | 3 | 0 |
232407 | 232407 | 2020-06-12 | Richland | Montana | 30083 | 3 | 0 |
235513 | 235513 | 2020-06-13 | Richland | Montana | 30083 | 3 | 0 |
238620 | 238620 | 2020-06-14 | Richland | Montana | 30083 | 3 | 0 |
241730 | 241730 | 2020-06-15 | Richland | Montana | 30083 | 3 | 0 |
244841 | 244841 | 2020-06-16 | Richland | Montana | 30083 | 3 | 0 |
247954 | 247954 | 2020-06-17 | Richland | Montana | 30083 | 3 | 0 |
251068 | 251068 | 2020-06-18 | Richland | Montana | 30083 | 5 | 0 |
254183 | 254183 | 2020-06-19 | Richland | Montana | 30083 | 5 | 0 |
257306 | 257306 | 2020-06-20 | Richland | Montana | 30083 | 6 | 0 |
260432 | 260432 | 2020-06-21 | Richland | Montana | 30083 | 8 | 0 |
263561 | 263561 | 2020-06-22 | Richland | Montana | 30083 | 8 | 0 |
266687 | 266687 | 2020-06-23 | Richland | Montana | 30083 | 8 | 0 |
269820 | 269820 | 2020-06-24 | Richland | Montana | 30083 | 9 | 0 |
272959 | 272959 | 2020-06-25 | Richland | Montana | 30083 | 9 | 0 |
276102 | 276102 | 2020-06-26 | Richland | Montana | 30083 | 10 | 0 |
279250 | 279250 | 2020-06-27 | Richland | Montana | 30083 | 10 | 0 |
282398 | 282398 | 2020-06-28 | Richland | Montana | 30083 | 10 | 0 |
285543 | 285543 | 2020-06-29 | Richland | Montana | 30083 | 12 | 0 |
288693 | 288693 | 2020-06-30 | Richland | Montana | 30083 | 12 | 0 |
291844 | 291844 | 2020-07-01 | Richland | Montana | 30083 | 12 | 0 |
294998 | 294998 | 2020-07-02 | Richland | Montana | 30083 | 18 | 0 |
298156 | 298156 | 2020-07-03 | Richland | Montana | 30083 | 18 | 0 |
301319 | 301319 | 2020-07-04 | Richland | Montana | 30083 | 19 | 0 |
304483 | 304483 | 2020-07-05 | Richland | Montana | 30083 | 22 | 0 |
307650 | 307650 | 2020-07-06 | Richland | Montana | 30083 | 22 | 0 |
310818 | 310818 | 2020-07-07 | Richland | Montana | 30083 | 22 | 0 |
313989 | 313989 | 2020-07-08 | Richland | Montana | 30083 | 22 | 0 |
317163 | 317163 | 2020-07-09 | Richland | Montana | 30083 | 22 | 0 |
320338 | 320338 | 2020-07-10 | Richland | Montana | 30083 | 28 | 0 |
323517 | 323517 | 2020-07-11 | Richland | Montana | 30083 | 28 | 0 |
326701 | 326701 | 2020-07-12 | Richland | Montana | 30083 | 30 | 0 |
329888 | 329888 | 2020-07-13 | Richland | Montana | 30083 | 30 | 0 |
333075 | 333075 | 2020-07-14 | Richland | Montana | 30083 | 30 | 0 |
336268 | 336268 | 2020-07-15 | Richland | Montana | 30083 | 32 | 0 |
339465 | 339465 | 2020-07-16 | Richland | Montana | 30083 | 33 | 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);