ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Gasconade" and state = "Missouri" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
25026 | 25026 | 2020-04-01 | Gasconade | Missouri | 29073 | 1 | 0 |
27281 | 27281 | 2020-04-02 | Gasconade | Missouri | 29073 | 1 | 0 |
29601 | 29601 | 2020-04-03 | Gasconade | Missouri | 29073 | 1 | 0 |
31981 | 31981 | 2020-04-04 | Gasconade | Missouri | 29073 | 2 | 0 |
34409 | 34409 | 2020-04-05 | Gasconade | Missouri | 29073 | 2 | 0 |
36872 | 36872 | 2020-04-06 | Gasconade | Missouri | 29073 | 2 | 0 |
39384 | 39384 | 2020-04-07 | Gasconade | Missouri | 29073 | 2 | 0 |
41938 | 41938 | 2020-04-08 | Gasconade | Missouri | 29073 | 2 | 0 |
44515 | 44515 | 2020-04-09 | Gasconade | Missouri | 29073 | 2 | 0 |
47124 | 47124 | 2020-04-10 | Gasconade | Missouri | 29073 | 2 | 0 |
49771 | 49771 | 2020-04-11 | Gasconade | Missouri | 29073 | 2 | 0 |
52444 | 52444 | 2020-04-12 | Gasconade | Missouri | 29073 | 2 | 0 |
55126 | 55126 | 2020-04-13 | Gasconade | Missouri | 29073 | 2 | 0 |
57824 | 57824 | 2020-04-14 | Gasconade | Missouri | 29073 | 2 | 0 |
60536 | 60536 | 2020-04-15 | Gasconade | Missouri | 29073 | 2 | 0 |
63258 | 63258 | 2020-04-16 | Gasconade | Missouri | 29073 | 2 | 0 |
65998 | 65998 | 2020-04-17 | Gasconade | Missouri | 29073 | 2 | 0 |
68750 | 68750 | 2020-04-18 | Gasconade | Missouri | 29073 | 2 | 0 |
71517 | 71517 | 2020-04-19 | Gasconade | Missouri | 29073 | 2 | 0 |
74290 | 74290 | 2020-04-20 | Gasconade | Missouri | 29073 | 2 | 0 |
77071 | 77071 | 2020-04-21 | Gasconade | Missouri | 29073 | 2 | 0 |
79857 | 79857 | 2020-04-22 | Gasconade | Missouri | 29073 | 2 | 0 |
82653 | 82653 | 2020-04-23 | Gasconade | Missouri | 29073 | 2 | 0 |
85457 | 85457 | 2020-04-24 | Gasconade | Missouri | 29073 | 2 | 0 |
88267 | 88267 | 2020-04-25 | Gasconade | Missouri | 29073 | 2 | 0 |
91083 | 91083 | 2020-04-26 | Gasconade | Missouri | 29073 | 2 | 0 |
93904 | 93904 | 2020-04-27 | Gasconade | Missouri | 29073 | 2 | 0 |
96740 | 96740 | 2020-04-28 | Gasconade | Missouri | 29073 | 2 | 0 |
99586 | 99586 | 2020-04-29 | Gasconade | Missouri | 29073 | 2 | 0 |
102438 | 102438 | 2020-04-30 | Gasconade | Missouri | 29073 | 2 | 0 |
105299 | 105299 | 2020-05-01 | Gasconade | Missouri | 29073 | 3 | 0 |
108164 | 108164 | 2020-05-02 | Gasconade | Missouri | 29073 | 2 | 0 |
111035 | 111035 | 2020-05-03 | Gasconade | Missouri | 29073 | 2 | 0 |
113914 | 113914 | 2020-05-04 | Gasconade | Missouri | 29073 | 2 | 0 |
116796 | 116796 | 2020-05-05 | Gasconade | Missouri | 29073 | 2 | 0 |
119756 | 119756 | 2020-05-06 | Gasconade | Missouri | 29073 | 2 | 0 |
122730 | 122730 | 2020-05-07 | Gasconade | Missouri | 29073 | 2 | 0 |
125712 | 125712 | 2020-05-08 | Gasconade | Missouri | 29073 | 2 | 0 |
128699 | 128699 | 2020-05-09 | Gasconade | Missouri | 29073 | 2 | 0 |
131689 | 131689 | 2020-05-10 | Gasconade | Missouri | 29073 | 2 | 0 |
134680 | 134680 | 2020-05-11 | Gasconade | Missouri | 29073 | 2 | 0 |
137670 | 137670 | 2020-05-12 | Gasconade | Missouri | 29073 | 2 | 0 |
140664 | 140664 | 2020-05-13 | Gasconade | Missouri | 29073 | 2 | 0 |
143659 | 143659 | 2020-05-14 | Gasconade | Missouri | 29073 | 2 | 0 |
146660 | 146660 | 2020-05-15 | Gasconade | Missouri | 29073 | 2 | 0 |
149665 | 149665 | 2020-05-16 | Gasconade | Missouri | 29073 | 2 | 0 |
152676 | 152676 | 2020-05-17 | Gasconade | Missouri | 29073 | 2 | 0 |
155690 | 155690 | 2020-05-18 | Gasconade | Missouri | 29073 | 2 | 0 |
158708 | 158708 | 2020-05-19 | Gasconade | Missouri | 29073 | 2 | 0 |
161734 | 161734 | 2020-05-20 | Gasconade | Missouri | 29073 | 2 | 0 |
164763 | 164763 | 2020-05-21 | Gasconade | Missouri | 29073 | 2 | 0 |
167799 | 167799 | 2020-05-22 | Gasconade | Missouri | 29073 | 2 | 0 |
170837 | 170837 | 2020-05-23 | Gasconade | Missouri | 29073 | 2 | 0 |
173879 | 173879 | 2020-05-24 | Gasconade | Missouri | 29073 | 2 | 0 |
176922 | 176922 | 2020-05-25 | Gasconade | Missouri | 29073 | 2 | 0 |
179966 | 179966 | 2020-05-26 | Gasconade | Missouri | 29073 | 2 | 0 |
183012 | 183012 | 2020-05-27 | Gasconade | Missouri | 29073 | 2 | 0 |
186068 | 186068 | 2020-05-28 | Gasconade | Missouri | 29073 | 2 | 0 |
189126 | 189126 | 2020-05-29 | Gasconade | Missouri | 29073 | 2 | 0 |
192190 | 192190 | 2020-05-30 | Gasconade | Missouri | 29073 | 2 | 0 |
195259 | 195259 | 2020-05-31 | Gasconade | Missouri | 29073 | 2 | 0 |
198330 | 198330 | 2020-06-01 | Gasconade | Missouri | 29073 | 2 | 0 |
201403 | 201403 | 2020-06-02 | Gasconade | Missouri | 29073 | 2 | 0 |
204480 | 204480 | 2020-06-03 | Gasconade | Missouri | 29073 | 2 | 0 |
207561 | 207561 | 2020-06-04 | Gasconade | Missouri | 29073 | 2 | 0 |
210642 | 210642 | 2020-06-05 | Gasconade | Missouri | 29073 | 2 | 0 |
213726 | 213726 | 2020-06-06 | Gasconade | Missouri | 29073 | 2 | 0 |
216814 | 216814 | 2020-06-07 | Gasconade | Missouri | 29073 | 2 | 0 |
219906 | 219906 | 2020-06-08 | Gasconade | Missouri | 29073 | 2 | 0 |
223001 | 223001 | 2020-06-09 | Gasconade | Missouri | 29073 | 2 | 0 |
226099 | 226099 | 2020-06-10 | Gasconade | Missouri | 29073 | 2 | 0 |
229202 | 229202 | 2020-06-11 | Gasconade | Missouri | 29073 | 2 | 0 |
232306 | 232306 | 2020-06-12 | Gasconade | Missouri | 29073 | 2 | 0 |
235412 | 235412 | 2020-06-13 | Gasconade | Missouri | 29073 | 2 | 0 |
238519 | 238519 | 2020-06-14 | Gasconade | Missouri | 29073 | 2 | 0 |
241629 | 241629 | 2020-06-15 | Gasconade | Missouri | 29073 | 2 | 0 |
244740 | 244740 | 2020-06-16 | Gasconade | Missouri | 29073 | 2 | 0 |
247853 | 247853 | 2020-06-17 | Gasconade | Missouri | 29073 | 2 | 0 |
250966 | 250966 | 2020-06-18 | Gasconade | Missouri | 29073 | 2 | 0 |
254081 | 254081 | 2020-06-19 | Gasconade | Missouri | 29073 | 3 | 0 |
257201 | 257201 | 2020-06-20 | Gasconade | Missouri | 29073 | 4 | 0 |
260327 | 260327 | 2020-06-21 | Gasconade | Missouri | 29073 | 4 | 0 |
263455 | 263455 | 2020-06-22 | Gasconade | Missouri | 29073 | 4 | 0 |
266581 | 266581 | 2020-06-23 | Gasconade | Missouri | 29073 | 5 | 0 |
269714 | 269714 | 2020-06-24 | Gasconade | Missouri | 29073 | 6 | 0 |
272852 | 272852 | 2020-06-25 | Gasconade | Missouri | 29073 | 7 | 0 |
275995 | 275995 | 2020-06-26 | Gasconade | Missouri | 29073 | 9 | 0 |
279143 | 279143 | 2020-06-27 | Gasconade | Missouri | 29073 | 11 | 0 |
282291 | 282291 | 2020-06-28 | Gasconade | Missouri | 29073 | 11 | 0 |
285436 | 285436 | 2020-06-29 | Gasconade | Missouri | 29073 | 12 | 0 |
288586 | 288586 | 2020-06-30 | Gasconade | Missouri | 29073 | 13 | 0 |
291737 | 291737 | 2020-07-01 | Gasconade | Missouri | 29073 | 13 | 0 |
294891 | 294891 | 2020-07-02 | Gasconade | Missouri | 29073 | 12 | 0 |
298049 | 298049 | 2020-07-03 | Gasconade | Missouri | 29073 | 12 | 0 |
301212 | 301212 | 2020-07-04 | Gasconade | Missouri | 29073 | 12 | 0 |
304376 | 304376 | 2020-07-05 | Gasconade | Missouri | 29073 | 12 | 0 |
307543 | 307543 | 2020-07-06 | Gasconade | Missouri | 29073 | 12 | 0 |
310711 | 310711 | 2020-07-07 | Gasconade | Missouri | 29073 | 12 | 0 |
313881 | 313881 | 2020-07-08 | Gasconade | Missouri | 29073 | 13 | 0 |
317055 | 317055 | 2020-07-09 | Gasconade | Missouri | 29073 | 13 | 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);