ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Grant" and fips = 35017 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
25165 | 25165 | 2020-04-01 | Grant | New Mexico | 35017 | 1 | 0 |
27425 | 27425 | 2020-04-02 | Grant | New Mexico | 35017 | 1 | 0 |
29748 | 29748 | 2020-04-03 | Grant | New Mexico | 35017 | 1 | 0 |
32133 | 32133 | 2020-04-04 | Grant | New Mexico | 35017 | 1 | 0 |
34564 | 34564 | 2020-04-05 | Grant | New Mexico | 35017 | 1 | 0 |
37034 | 37034 | 2020-04-06 | Grant | New Mexico | 35017 | 3 | 0 |
39549 | 39549 | 2020-04-07 | Grant | New Mexico | 35017 | 4 | 0 |
42106 | 42106 | 2020-04-08 | Grant | New Mexico | 35017 | 4 | 0 |
44689 | 44689 | 2020-04-09 | Grant | New Mexico | 35017 | 4 | 0 |
47301 | 47301 | 2020-04-10 | Grant | New Mexico | 35017 | 7 | 0 |
49955 | 49955 | 2020-04-11 | Grant | New Mexico | 35017 | 8 | 0 |
52628 | 52628 | 2020-04-12 | Grant | New Mexico | 35017 | 9 | 0 |
55311 | 55311 | 2020-04-13 | Grant | New Mexico | 35017 | 10 | 0 |
58011 | 58011 | 2020-04-14 | Grant | New Mexico | 35017 | 10 | 0 |
60725 | 60725 | 2020-04-15 | Grant | New Mexico | 35017 | 11 | 0 |
63451 | 63451 | 2020-04-16 | Grant | New Mexico | 35017 | 12 | 0 |
66193 | 66193 | 2020-04-17 | Grant | New Mexico | 35017 | 13 | 0 |
68949 | 68949 | 2020-04-18 | Grant | New Mexico | 35017 | 13 | 0 |
71716 | 71716 | 2020-04-19 | Grant | New Mexico | 35017 | 13 | 0 |
74491 | 74491 | 2020-04-20 | Grant | New Mexico | 35017 | 14 | 0 |
77272 | 77272 | 2020-04-21 | Grant | New Mexico | 35017 | 14 | 0 |
80061 | 80061 | 2020-04-22 | Grant | New Mexico | 35017 | 14 | 0 |
82859 | 82859 | 2020-04-23 | Grant | New Mexico | 35017 | 14 | 0 |
85663 | 85663 | 2020-04-24 | Grant | New Mexico | 35017 | 14 | 0 |
88474 | 88474 | 2020-04-25 | Grant | New Mexico | 35017 | 14 | 0 |
91289 | 91289 | 2020-04-26 | Grant | New Mexico | 35017 | 14 | 0 |
94113 | 94113 | 2020-04-27 | Grant | New Mexico | 35017 | 14 | 0 |
96949 | 96949 | 2020-04-28 | Grant | New Mexico | 35017 | 14 | 0 |
99796 | 99796 | 2020-04-29 | Grant | New Mexico | 35017 | 14 | 0 |
102649 | 102649 | 2020-04-30 | Grant | New Mexico | 35017 | 14 | 0 |
105511 | 105511 | 2020-05-01 | Grant | New Mexico | 35017 | 14 | 0 |
108377 | 108377 | 2020-05-02 | Grant | New Mexico | 35017 | 15 | 0 |
111250 | 111250 | 2020-05-03 | Grant | New Mexico | 35017 | 16 | 0 |
114131 | 114131 | 2020-05-04 | Grant | New Mexico | 35017 | 15 | 0 |
117012 | 117012 | 2020-05-05 | Grant | New Mexico | 35017 | 15 | 0 |
119973 | 119973 | 2020-05-06 | Grant | New Mexico | 35017 | 15 | 0 |
122948 | 122948 | 2020-05-07 | Grant | New Mexico | 35017 | 15 | 0 |
125931 | 125931 | 2020-05-08 | Grant | New Mexico | 35017 | 15 | 0 |
128920 | 128920 | 2020-05-09 | Grant | New Mexico | 35017 | 15 | 0 |
131909 | 131909 | 2020-05-10 | Grant | New Mexico | 35017 | 15 | 0 |
134900 | 134900 | 2020-05-11 | Grant | New Mexico | 35017 | 15 | 0 |
137890 | 137890 | 2020-05-12 | Grant | New Mexico | 35017 | 15 | 0 |
140886 | 140886 | 2020-05-13 | Grant | New Mexico | 35017 | 15 | 0 |
143881 | 143881 | 2020-05-14 | Grant | New Mexico | 35017 | 16 | 0 |
146882 | 146882 | 2020-05-15 | Grant | New Mexico | 35017 | 16 | 0 |
149889 | 149889 | 2020-05-16 | Grant | New Mexico | 35017 | 16 | 0 |
152899 | 152899 | 2020-05-17 | Grant | New Mexico | 35017 | 16 | 0 |
155915 | 155915 | 2020-05-18 | Grant | New Mexico | 35017 | 16 | 0 |
158933 | 158933 | 2020-05-19 | Grant | New Mexico | 35017 | 16 | 0 |
161959 | 161959 | 2020-05-20 | Grant | New Mexico | 35017 | 16 | 0 |
164988 | 164988 | 2020-05-21 | Grant | New Mexico | 35017 | 16 | 0 |
168024 | 168024 | 2020-05-22 | Grant | New Mexico | 35017 | 16 | 0 |
171063 | 171063 | 2020-05-23 | Grant | New Mexico | 35017 | 16 | 0 |
174105 | 174105 | 2020-05-24 | Grant | New Mexico | 35017 | 16 | 0 |
177148 | 177148 | 2020-05-25 | Grant | New Mexico | 35017 | 16 | 0 |
180192 | 180192 | 2020-05-26 | Grant | New Mexico | 35017 | 15 | 0 |
183240 | 183240 | 2020-05-27 | Grant | New Mexico | 35017 | 15 | 0 |
186297 | 186297 | 2020-05-28 | Grant | New Mexico | 35017 | 15 | 0 |
189357 | 189357 | 2020-05-29 | Grant | New Mexico | 35017 | 15 | 0 |
192421 | 192421 | 2020-05-30 | Grant | New Mexico | 35017 | 15 | 0 |
195491 | 195491 | 2020-05-31 | Grant | New Mexico | 35017 | 15 | 0 |
198564 | 198564 | 2020-06-01 | Grant | New Mexico | 35017 | 15 | 0 |
201638 | 201638 | 2020-06-02 | Grant | New Mexico | 35017 | 15 | 0 |
204715 | 204715 | 2020-06-03 | Grant | New Mexico | 35017 | 15 | 0 |
207796 | 207796 | 2020-06-04 | Grant | New Mexico | 35017 | 15 | 0 |
210878 | 210878 | 2020-06-05 | Grant | New Mexico | 35017 | 15 | 0 |
213962 | 213962 | 2020-06-06 | Grant | New Mexico | 35017 | 15 | 0 |
217051 | 217051 | 2020-06-07 | Grant | New Mexico | 35017 | 15 | 0 |
220143 | 220143 | 2020-06-08 | Grant | New Mexico | 35017 | 15 | 0 |
223238 | 223238 | 2020-06-09 | Grant | New Mexico | 35017 | 15 | 0 |
226338 | 226338 | 2020-06-10 | Grant | New Mexico | 35017 | 15 | 0 |
229442 | 229442 | 2020-06-11 | Grant | New Mexico | 35017 | 16 | 0 |
232547 | 232547 | 2020-06-12 | Grant | New Mexico | 35017 | 17 | 0 |
235652 | 235652 | 2020-06-13 | Grant | New Mexico | 35017 | 16 | 0 |
238759 | 238759 | 2020-06-14 | Grant | New Mexico | 35017 | 16 | 0 |
241869 | 241869 | 2020-06-15 | Grant | New Mexico | 35017 | 16 | 0 |
244981 | 244981 | 2020-06-16 | Grant | New Mexico | 35017 | 16 | 0 |
248094 | 248094 | 2020-06-17 | Grant | New Mexico | 35017 | 16 | 0 |
251209 | 251209 | 2020-06-18 | Grant | New Mexico | 35017 | 16 | 0 |
254324 | 254324 | 2020-06-19 | Grant | New Mexico | 35017 | 16 | 0 |
257447 | 257447 | 2020-06-20 | Grant | New Mexico | 35017 | 16 | 0 |
260573 | 260573 | 2020-06-21 | Grant | New Mexico | 35017 | 17 | 0 |
263702 | 263702 | 2020-06-22 | Grant | New Mexico | 35017 | 17 | 0 |
266829 | 266829 | 2020-06-23 | Grant | New Mexico | 35017 | 17 | 0 |
269964 | 269964 | 2020-06-24 | Grant | New Mexico | 35017 | 17 | 0 |
273103 | 273103 | 2020-06-25 | Grant | New Mexico | 35017 | 17 | 0 |
276248 | 276248 | 2020-06-26 | Grant | New Mexico | 35017 | 17 | 0 |
279396 | 279396 | 2020-06-27 | Grant | New Mexico | 35017 | 18 | 0 |
282543 | 282543 | 2020-06-28 | Grant | New Mexico | 35017 | 18 | 0 |
285688 | 285688 | 2020-06-29 | Grant | New Mexico | 35017 | 18 | 0 |
288838 | 288838 | 2020-06-30 | Grant | New Mexico | 35017 | 18 | 0 |
291990 | 291990 | 2020-07-01 | Grant | New Mexico | 35017 | 19 | 0 |
295145 | 295145 | 2020-07-02 | Grant | New Mexico | 35017 | 20 | 0 |
298305 | 298305 | 2020-07-03 | Grant | New Mexico | 35017 | 21 | 0 |
301468 | 301468 | 2020-07-04 | Grant | New Mexico | 35017 | 22 | 0 |
304631 | 304631 | 2020-07-05 | Grant | New Mexico | 35017 | 24 | 0 |
307798 | 307798 | 2020-07-06 | Grant | New Mexico | 35017 | 24 | 0 |
310966 | 310966 | 2020-07-07 | Grant | New Mexico | 35017 | 24 | 0 |
314137 | 314137 | 2020-07-08 | Grant | New Mexico | 35017 | 27 | 0 |
317311 | 317311 | 2020-07-09 | Grant | New Mexico | 35017 | 29 | 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);