ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where county = "Lincoln" and state = "New Mexico" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
32135 | 32135 | 2020-04-04 | Lincoln | New Mexico | 35027 | 1 | 0 |
34566 | 34566 | 2020-04-05 | Lincoln | New Mexico | 35027 | 1 | 0 |
37036 | 37036 | 2020-04-06 | Lincoln | New Mexico | 35027 | 1 | 0 |
39551 | 39551 | 2020-04-07 | Lincoln | New Mexico | 35027 | 1 | 0 |
42108 | 42108 | 2020-04-08 | Lincoln | New Mexico | 35027 | 1 | 0 |
44691 | 44691 | 2020-04-09 | Lincoln | New Mexico | 35027 | 1 | 0 |
47303 | 47303 | 2020-04-10 | Lincoln | New Mexico | 35027 | 1 | 0 |
49957 | 49957 | 2020-04-11 | Lincoln | New Mexico | 35027 | 1 | 0 |
52630 | 52630 | 2020-04-12 | Lincoln | New Mexico | 35027 | 1 | 0 |
55313 | 55313 | 2020-04-13 | Lincoln | New Mexico | 35027 | 1 | 0 |
58013 | 58013 | 2020-04-14 | Lincoln | New Mexico | 35027 | 1 | 0 |
60727 | 60727 | 2020-04-15 | Lincoln | New Mexico | 35027 | 1 | 0 |
63453 | 63453 | 2020-04-16 | Lincoln | New Mexico | 35027 | 1 | 0 |
66195 | 66195 | 2020-04-17 | Lincoln | New Mexico | 35027 | 1 | 0 |
68952 | 68952 | 2020-04-18 | Lincoln | New Mexico | 35027 | 1 | 0 |
71719 | 71719 | 2020-04-19 | Lincoln | New Mexico | 35027 | 1 | 0 |
74494 | 74494 | 2020-04-20 | Lincoln | New Mexico | 35027 | 1 | 0 |
77275 | 77275 | 2020-04-21 | Lincoln | New Mexico | 35027 | 2 | 0 |
80064 | 80064 | 2020-04-22 | Lincoln | New Mexico | 35027 | 2 | 0 |
82863 | 82863 | 2020-04-23 | Lincoln | New Mexico | 35027 | 2 | 0 |
85667 | 85667 | 2020-04-24 | Lincoln | New Mexico | 35027 | 2 | 0 |
88478 | 88478 | 2020-04-25 | Lincoln | New Mexico | 35027 | 2 | 0 |
91293 | 91293 | 2020-04-26 | Lincoln | New Mexico | 35027 | 2 | 0 |
94117 | 94117 | 2020-04-27 | Lincoln | New Mexico | 35027 | 2 | 0 |
96953 | 96953 | 2020-04-28 | Lincoln | New Mexico | 35027 | 2 | 0 |
99800 | 99800 | 2020-04-29 | Lincoln | New Mexico | 35027 | 2 | 0 |
102653 | 102653 | 2020-04-30 | Lincoln | New Mexico | 35027 | 2 | 0 |
105515 | 105515 | 2020-05-01 | Lincoln | New Mexico | 35027 | 2 | 0 |
108381 | 108381 | 2020-05-02 | Lincoln | New Mexico | 35027 | 2 | 0 |
111254 | 111254 | 2020-05-03 | Lincoln | New Mexico | 35027 | 2 | 0 |
114135 | 114135 | 2020-05-04 | Lincoln | New Mexico | 35027 | 2 | 0 |
117016 | 117016 | 2020-05-05 | Lincoln | New Mexico | 35027 | 2 | 0 |
119977 | 119977 | 2020-05-06 | Lincoln | New Mexico | 35027 | 2 | 0 |
122952 | 122952 | 2020-05-07 | Lincoln | New Mexico | 35027 | 2 | 0 |
125935 | 125935 | 2020-05-08 | Lincoln | New Mexico | 35027 | 2 | 0 |
128924 | 128924 | 2020-05-09 | Lincoln | New Mexico | 35027 | 2 | 0 |
131913 | 131913 | 2020-05-10 | Lincoln | New Mexico | 35027 | 2 | 0 |
134904 | 134904 | 2020-05-11 | Lincoln | New Mexico | 35027 | 2 | 0 |
137894 | 137894 | 2020-05-12 | Lincoln | New Mexico | 35027 | 2 | 0 |
140890 | 140890 | 2020-05-13 | Lincoln | New Mexico | 35027 | 2 | 0 |
143885 | 143885 | 2020-05-14 | Lincoln | New Mexico | 35027 | 2 | 0 |
146886 | 146886 | 2020-05-15 | Lincoln | New Mexico | 35027 | 2 | 0 |
149893 | 149893 | 2020-05-16 | Lincoln | New Mexico | 35027 | 3 | 0 |
152903 | 152903 | 2020-05-17 | Lincoln | New Mexico | 35027 | 3 | 0 |
155920 | 155920 | 2020-05-18 | Lincoln | New Mexico | 35027 | 3 | 0 |
158938 | 158938 | 2020-05-19 | Lincoln | New Mexico | 35027 | 3 | 0 |
161964 | 161964 | 2020-05-20 | Lincoln | New Mexico | 35027 | 3 | 0 |
164993 | 164993 | 2020-05-21 | Lincoln | New Mexico | 35027 | 3 | 0 |
168029 | 168029 | 2020-05-22 | Lincoln | New Mexico | 35027 | 3 | 0 |
171068 | 171068 | 2020-05-23 | Lincoln | New Mexico | 35027 | 3 | 0 |
174110 | 174110 | 2020-05-24 | Lincoln | New Mexico | 35027 | 3 | 0 |
177153 | 177153 | 2020-05-25 | Lincoln | New Mexico | 35027 | 3 | 0 |
180197 | 180197 | 2020-05-26 | Lincoln | New Mexico | 35027 | 2 | 0 |
183245 | 183245 | 2020-05-27 | Lincoln | New Mexico | 35027 | 2 | 0 |
186302 | 186302 | 2020-05-28 | Lincoln | New Mexico | 35027 | 2 | 0 |
189362 | 189362 | 2020-05-29 | Lincoln | New Mexico | 35027 | 2 | 0 |
192426 | 192426 | 2020-05-30 | Lincoln | New Mexico | 35027 | 2 | 0 |
195496 | 195496 | 2020-05-31 | Lincoln | New Mexico | 35027 | 2 | 0 |
198569 | 198569 | 2020-06-01 | Lincoln | New Mexico | 35027 | 2 | 0 |
201643 | 201643 | 2020-06-02 | Lincoln | New Mexico | 35027 | 4 | 0 |
204720 | 204720 | 2020-06-03 | Lincoln | New Mexico | 35027 | 5 | 0 |
207801 | 207801 | 2020-06-04 | Lincoln | New Mexico | 35027 | 5 | 0 |
210883 | 210883 | 2020-06-05 | Lincoln | New Mexico | 35027 | 5 | 0 |
213967 | 213967 | 2020-06-06 | Lincoln | New Mexico | 35027 | 5 | 0 |
217056 | 217056 | 2020-06-07 | Lincoln | New Mexico | 35027 | 5 | 0 |
220148 | 220148 | 2020-06-08 | Lincoln | New Mexico | 35027 | 5 | 0 |
223243 | 223243 | 2020-06-09 | Lincoln | New Mexico | 35027 | 5 | 0 |
226343 | 226343 | 2020-06-10 | Lincoln | New Mexico | 35027 | 5 | 0 |
229447 | 229447 | 2020-06-11 | Lincoln | New Mexico | 35027 | 5 | 0 |
232552 | 232552 | 2020-06-12 | Lincoln | New Mexico | 35027 | 5 | 0 |
235657 | 235657 | 2020-06-13 | Lincoln | New Mexico | 35027 | 5 | 0 |
238764 | 238764 | 2020-06-14 | Lincoln | New Mexico | 35027 | 6 | 0 |
241874 | 241874 | 2020-06-15 | Lincoln | New Mexico | 35027 | 6 | 0 |
244986 | 244986 | 2020-06-16 | Lincoln | New Mexico | 35027 | 6 | 0 |
248099 | 248099 | 2020-06-17 | Lincoln | New Mexico | 35027 | 6 | 0 |
251214 | 251214 | 2020-06-18 | Lincoln | New Mexico | 35027 | 7 | 0 |
254329 | 254329 | 2020-06-19 | Lincoln | New Mexico | 35027 | 7 | 0 |
257452 | 257452 | 2020-06-20 | Lincoln | New Mexico | 35027 | 7 | 0 |
260578 | 260578 | 2020-06-21 | Lincoln | New Mexico | 35027 | 7 | 0 |
263707 | 263707 | 2020-06-22 | Lincoln | New Mexico | 35027 | 7 | 0 |
266834 | 266834 | 2020-06-23 | Lincoln | New Mexico | 35027 | 7 | 0 |
269969 | 269969 | 2020-06-24 | Lincoln | New Mexico | 35027 | 8 | 0 |
273108 | 273108 | 2020-06-25 | Lincoln | New Mexico | 35027 | 9 | 0 |
276253 | 276253 | 2020-06-26 | Lincoln | New Mexico | 35027 | 11 | 0 |
279401 | 279401 | 2020-06-27 | Lincoln | New Mexico | 35027 | 11 | 0 |
282548 | 282548 | 2020-06-28 | Lincoln | New Mexico | 35027 | 11 | 0 |
285693 | 285693 | 2020-06-29 | Lincoln | New Mexico | 35027 | 11 | 0 |
288843 | 288843 | 2020-06-30 | Lincoln | New Mexico | 35027 | 11 | 0 |
291995 | 291995 | 2020-07-01 | Lincoln | New Mexico | 35027 | 11 | 0 |
295150 | 295150 | 2020-07-02 | Lincoln | New Mexico | 35027 | 12 | 0 |
298310 | 298310 | 2020-07-03 | Lincoln | New Mexico | 35027 | 13 | 0 |
301473 | 301473 | 2020-07-04 | Lincoln | New Mexico | 35027 | 13 | 0 |
304636 | 304636 | 2020-07-05 | Lincoln | New Mexico | 35027 | 13 | 0 |
307803 | 307803 | 2020-07-06 | Lincoln | New Mexico | 35027 | 14 | 0 |
310971 | 310971 | 2020-07-07 | Lincoln | New Mexico | 35027 | 14 | 0 |
314142 | 314142 | 2020-07-08 | Lincoln | New Mexico | 35027 | 16 | 0 |
317316 | 317316 | 2020-07-09 | Lincoln | New Mexico | 35027 | 18 | 0 |
320492 | 320492 | 2020-07-10 | Lincoln | New Mexico | 35027 | 19 | 0 |
323672 | 323672 | 2020-07-11 | Lincoln | New Mexico | 35027 | 22 | 0 |
326856 | 326856 | 2020-07-12 | Lincoln | New Mexico | 35027 | 24 | 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);