ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Grant", fips = 38037 and state = "North Dakota" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
23128 | 23128 | 2020-03-31 | Grant | North Dakota | 38037 | 1 | 0 |
25323 | 25323 | 2020-04-01 | Grant | North Dakota | 38037 | 1 | 0 |
27589 | 27589 | 2020-04-02 | Grant | North Dakota | 38037 | 1 | 0 |
29917 | 29917 | 2020-04-03 | Grant | North Dakota | 38037 | 1 | 0 |
32305 | 32305 | 2020-04-04 | Grant | North Dakota | 38037 | 1 | 0 |
34738 | 34738 | 2020-04-05 | Grant | North Dakota | 38037 | 1 | 0 |
37207 | 37207 | 2020-04-06 | Grant | North Dakota | 38037 | 1 | 0 |
39724 | 39724 | 2020-04-07 | Grant | North Dakota | 38037 | 1 | 0 |
42281 | 42281 | 2020-04-08 | Grant | North Dakota | 38037 | 1 | 0 |
44865 | 44865 | 2020-04-09 | Grant | North Dakota | 38037 | 1 | 0 |
47478 | 47478 | 2020-04-10 | Grant | North Dakota | 38037 | 1 | 0 |
50133 | 50133 | 2020-04-11 | Grant | North Dakota | 38037 | 1 | 0 |
52806 | 52806 | 2020-04-12 | Grant | North Dakota | 38037 | 1 | 0 |
55490 | 55490 | 2020-04-13 | Grant | North Dakota | 38037 | 1 | 0 |
58191 | 58191 | 2020-04-14 | Grant | North Dakota | 38037 | 1 | 0 |
60905 | 60905 | 2020-04-15 | Grant | North Dakota | 38037 | 1 | 0 |
63631 | 63631 | 2020-04-16 | Grant | North Dakota | 38037 | 1 | 0 |
66374 | 66374 | 2020-04-17 | Grant | North Dakota | 38037 | 1 | 0 |
69131 | 69131 | 2020-04-18 | Grant | North Dakota | 38037 | 1 | 0 |
71897 | 71897 | 2020-04-19 | Grant | North Dakota | 38037 | 1 | 0 |
74672 | 74672 | 2020-04-20 | Grant | North Dakota | 38037 | 1 | 0 |
77453 | 77453 | 2020-04-21 | Grant | North Dakota | 38037 | 1 | 0 |
80242 | 80242 | 2020-04-22 | Grant | North Dakota | 38037 | 1 | 0 |
83041 | 83041 | 2020-04-23 | Grant | North Dakota | 38037 | 1 | 0 |
85845 | 85845 | 2020-04-24 | Grant | North Dakota | 38037 | 1 | 0 |
88658 | 88658 | 2020-04-25 | Grant | North Dakota | 38037 | 1 | 0 |
91473 | 91473 | 2020-04-26 | Grant | North Dakota | 38037 | 1 | 0 |
94299 | 94299 | 2020-04-27 | Grant | North Dakota | 38037 | 1 | 0 |
97136 | 97136 | 2020-04-28 | Grant | North Dakota | 38037 | 1 | 0 |
99985 | 99985 | 2020-04-29 | Grant | North Dakota | 38037 | 1 | 0 |
102838 | 102838 | 2020-04-30 | Grant | North Dakota | 38037 | 1 | 0 |
105700 | 105700 | 2020-05-01 | Grant | North Dakota | 38037 | 1 | 0 |
108567 | 108567 | 2020-05-02 | Grant | North Dakota | 38037 | 1 | 0 |
111441 | 111441 | 2020-05-03 | Grant | North Dakota | 38037 | 1 | 0 |
114322 | 114322 | 2020-05-04 | Grant | North Dakota | 38037 | 1 | 0 |
117202 | 117202 | 2020-05-05 | Grant | North Dakota | 38037 | 1 | 0 |
120163 | 120163 | 2020-05-06 | Grant | North Dakota | 38037 | 1 | 0 |
123139 | 123139 | 2020-05-07 | Grant | North Dakota | 38037 | 1 | 0 |
126122 | 126122 | 2020-05-08 | Grant | North Dakota | 38037 | 1 | 0 |
129111 | 129111 | 2020-05-09 | Grant | North Dakota | 38037 | 1 | 0 |
132100 | 132100 | 2020-05-10 | Grant | North Dakota | 38037 | 1 | 0 |
135091 | 135091 | 2020-05-11 | Grant | North Dakota | 38037 | 2 | 0 |
138081 | 138081 | 2020-05-12 | Grant | North Dakota | 38037 | 2 | 0 |
141077 | 141077 | 2020-05-13 | Grant | North Dakota | 38037 | 2 | 0 |
144072 | 144072 | 2020-05-14 | Grant | North Dakota | 38037 | 2 | 0 |
147073 | 147073 | 2020-05-15 | Grant | North Dakota | 38037 | 2 | 0 |
150080 | 150080 | 2020-05-16 | Grant | North Dakota | 38037 | 2 | 0 |
153090 | 153090 | 2020-05-17 | Grant | North Dakota | 38037 | 2 | 0 |
156107 | 156107 | 2020-05-18 | Grant | North Dakota | 38037 | 2 | 0 |
159127 | 159127 | 2020-05-19 | Grant | North Dakota | 38037 | 2 | 0 |
162154 | 162154 | 2020-05-20 | Grant | North Dakota | 38037 | 2 | 0 |
165183 | 165183 | 2020-05-21 | Grant | North Dakota | 38037 | 2 | 0 |
168218 | 168218 | 2020-05-22 | Grant | North Dakota | 38037 | 2 | 0 |
171257 | 171257 | 2020-05-23 | Grant | North Dakota | 38037 | 2 | 0 |
174299 | 174299 | 2020-05-24 | Grant | North Dakota | 38037 | 2 | 0 |
177343 | 177343 | 2020-05-25 | Grant | North Dakota | 38037 | 2 | 0 |
180386 | 180386 | 2020-05-26 | Grant | North Dakota | 38037 | 2 | 0 |
183434 | 183434 | 2020-05-27 | Grant | North Dakota | 38037 | 2 | 0 |
186491 | 186491 | 2020-05-28 | Grant | North Dakota | 38037 | 2 | 0 |
189551 | 189551 | 2020-05-29 | Grant | North Dakota | 38037 | 2 | 0 |
192615 | 192615 | 2020-05-30 | Grant | North Dakota | 38037 | 2 | 0 |
195685 | 195685 | 2020-05-31 | Grant | North Dakota | 38037 | 2 | 0 |
198758 | 198758 | 2020-06-01 | Grant | North Dakota | 38037 | 2 | 0 |
201833 | 201833 | 2020-06-02 | Grant | North Dakota | 38037 | 2 | 0 |
204910 | 204910 | 2020-06-03 | Grant | North Dakota | 38037 | 2 | 0 |
207991 | 207991 | 2020-06-04 | Grant | North Dakota | 38037 | 2 | 0 |
211073 | 211073 | 2020-06-05 | Grant | North Dakota | 38037 | 2 | 0 |
214157 | 214157 | 2020-06-06 | Grant | North Dakota | 38037 | 2 | 0 |
217247 | 217247 | 2020-06-07 | Grant | North Dakota | 38037 | 2 | 0 |
220339 | 220339 | 2020-06-08 | Grant | North Dakota | 38037 | 2 | 0 |
223433 | 223433 | 2020-06-09 | Grant | North Dakota | 38037 | 2 | 0 |
226533 | 226533 | 2020-06-10 | Grant | North Dakota | 38037 | 2 | 0 |
229637 | 229637 | 2020-06-11 | Grant | North Dakota | 38037 | 2 | 0 |
232742 | 232742 | 2020-06-12 | Grant | North Dakota | 38037 | 2 | 0 |
235847 | 235847 | 2020-06-13 | Grant | North Dakota | 38037 | 2 | 0 |
238955 | 238955 | 2020-06-14 | Grant | North Dakota | 38037 | 2 | 0 |
242064 | 242064 | 2020-06-15 | Grant | North Dakota | 38037 | 2 | 0 |
245176 | 245176 | 2020-06-16 | Grant | North Dakota | 38037 | 2 | 0 |
248289 | 248289 | 2020-06-17 | Grant | North Dakota | 38037 | 2 | 0 |
251404 | 251404 | 2020-06-18 | Grant | North Dakota | 38037 | 2 | 0 |
254519 | 254519 | 2020-06-19 | Grant | North Dakota | 38037 | 2 | 0 |
257644 | 257644 | 2020-06-20 | Grant | North Dakota | 38037 | 2 | 0 |
260771 | 260771 | 2020-06-21 | Grant | North Dakota | 38037 | 2 | 0 |
263899 | 263899 | 2020-06-22 | Grant | North Dakota | 38037 | 2 | 0 |
267027 | 267027 | 2020-06-23 | Grant | North Dakota | 38037 | 2 | 0 |
270161 | 270161 | 2020-06-24 | Grant | North Dakota | 38037 | 2 | 0 |
273300 | 273300 | 2020-06-25 | Grant | North Dakota | 38037 | 2 | 0 |
276446 | 276446 | 2020-06-26 | Grant | North Dakota | 38037 | 2 | 0 |
279594 | 279594 | 2020-06-27 | Grant | North Dakota | 38037 | 2 | 0 |
282740 | 282740 | 2020-06-28 | Grant | North Dakota | 38037 | 3 | 0 |
285885 | 285885 | 2020-06-29 | Grant | North Dakota | 38037 | 3 | 0 |
289035 | 289035 | 2020-06-30 | Grant | North Dakota | 38037 | 3 | 0 |
292187 | 292187 | 2020-07-01 | Grant | North Dakota | 38037 | 3 | 0 |
295342 | 295342 | 2020-07-02 | Grant | North Dakota | 38037 | 3 | 0 |
298502 | 298502 | 2020-07-03 | Grant | North Dakota | 38037 | 3 | 0 |
301665 | 301665 | 2020-07-04 | Grant | North Dakota | 38037 | 3 | 0 |
304828 | 304828 | 2020-07-05 | Grant | North Dakota | 38037 | 3 | 0 |
307995 | 307995 | 2020-07-06 | Grant | North Dakota | 38037 | 3 | 0 |
311163 | 311163 | 2020-07-07 | Grant | North Dakota | 38037 | 3 | 0 |
314334 | 314334 | 2020-07-08 | Grant | North Dakota | 38037 | 3 | 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);