ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,510 rows where county = "Lane" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
167238 | 167238 | 2020-05-22 | Lane | Kansas | 20101 | 1 | 0 |
170276 | 170276 | 2020-05-23 | Lane | Kansas | 20101 | 1 | 0 |
173317 | 173317 | 2020-05-24 | Lane | Kansas | 20101 | 1 | 0 |
3615 | 3615 | 2020-03-17 | Lane | Oregon | 41039 | 2 | 1 |
4230 | 4230 | 2020-03-18 | Lane | Oregon | 41039 | 2 | 1 |
4969 | 4969 | 2020-03-19 | Lane | Oregon | 41039 | 2 | 1 |
5837 | 5837 | 2020-03-20 | Lane | Oregon | 41039 | 2 | 1 |
6839 | 6839 | 2020-03-21 | Lane | Oregon | 41039 | 3 | 1 |
176361 | 176361 | 2020-05-25 | Lane | Kansas | 20101 | 3 | 0 |
179405 | 179405 | 2020-05-26 | Lane | Kansas | 20101 | 3 | 0 |
182450 | 182450 | 2020-05-27 | Lane | Kansas | 20101 | 3 | 0 |
185504 | 185504 | 2020-05-28 | Lane | Kansas | 20101 | 3 | 0 |
188562 | 188562 | 2020-05-29 | Lane | Kansas | 20101 | 3 | 0 |
191626 | 191626 | 2020-05-30 | Lane | Kansas | 20101 | 3 | 0 |
194694 | 194694 | 2020-05-31 | Lane | Kansas | 20101 | 3 | 0 |
197764 | 197764 | 2020-06-01 | Lane | Kansas | 20101 | 3 | 0 |
200836 | 200836 | 2020-06-02 | Lane | Kansas | 20101 | 3 | 0 |
7954 | 7954 | 2020-03-22 | Lane | Oregon | 41039 | 4 | 1 |
9164 | 9164 | 2020-03-23 | Lane | Oregon | 41039 | 4 | 1 |
10483 | 10483 | 2020-03-24 | Lane | Oregon | 41039 | 4 | 1 |
203912 | 203912 | 2020-06-03 | Lane | Kansas | 20101 | 4 | 0 |
206993 | 206993 | 2020-06-04 | Lane | Kansas | 20101 | 4 | 0 |
210074 | 210074 | 2020-06-05 | Lane | Kansas | 20101 | 4 | 0 |
213159 | 213159 | 2020-06-06 | Lane | Kansas | 20101 | 4 | 0 |
216246 | 216246 | 2020-06-07 | Lane | Kansas | 20101 | 4 | 0 |
219338 | 219338 | 2020-06-08 | Lane | Kansas | 20101 | 4 | 0 |
222433 | 222433 | 2020-06-09 | Lane | Kansas | 20101 | 4 | 0 |
225528 | 225528 | 2020-06-10 | Lane | Kansas | 20101 | 4 | 0 |
228630 | 228630 | 2020-06-11 | Lane | Kansas | 20101 | 4 | 0 |
231733 | 231733 | 2020-06-12 | Lane | Kansas | 20101 | 4 | 0 |
234839 | 234839 | 2020-06-13 | Lane | Kansas | 20101 | 4 | 0 |
237946 | 237946 | 2020-06-14 | Lane | Kansas | 20101 | 4 | 0 |
241055 | 241055 | 2020-06-15 | Lane | Kansas | 20101 | 4 | 0 |
244166 | 244166 | 2020-06-16 | Lane | Kansas | 20101 | 4 | 0 |
247279 | 247279 | 2020-06-17 | Lane | Kansas | 20101 | 4 | 0 |
250391 | 250391 | 2020-06-18 | Lane | Kansas | 20101 | 4 | 0 |
11944 | 11944 | 2020-03-25 | Lane | Oregon | 41039 | 5 | 1 |
253506 | 253506 | 2020-06-19 | Lane | Kansas | 20101 | 5 | 0 |
256626 | 256626 | 2020-06-20 | Lane | Kansas | 20101 | 5 | 0 |
259752 | 259752 | 2020-06-21 | Lane | Kansas | 20101 | 5 | 0 |
262879 | 262879 | 2020-06-22 | Lane | Kansas | 20101 | 5 | 0 |
266007 | 266007 | 2020-06-23 | Lane | Kansas | 20101 | 5 | 0 |
269137 | 269137 | 2020-06-24 | Lane | Kansas | 20101 | 5 | 0 |
272274 | 272274 | 2020-06-25 | Lane | Kansas | 20101 | 5 | 0 |
275417 | 275417 | 2020-06-26 | Lane | Kansas | 20101 | 5 | 0 |
278565 | 278565 | 2020-06-27 | Lane | Kansas | 20101 | 5 | 0 |
281713 | 281713 | 2020-06-28 | Lane | Kansas | 20101 | 5 | 0 |
284858 | 284858 | 2020-06-29 | Lane | Kansas | 20101 | 5 | 0 |
288007 | 288007 | 2020-06-30 | Lane | Kansas | 20101 | 5 | 0 |
291157 | 291157 | 2020-07-01 | Lane | Kansas | 20101 | 5 | 0 |
294311 | 294311 | 2020-07-02 | Lane | Kansas | 20101 | 5 | 0 |
297469 | 297469 | 2020-07-03 | Lane | Kansas | 20101 | 5 | 0 |
300631 | 300631 | 2020-07-04 | Lane | Kansas | 20101 | 5 | 0 |
303795 | 303795 | 2020-07-05 | Lane | Kansas | 20101 | 5 | 0 |
306962 | 306962 | 2020-07-06 | Lane | Kansas | 20101 | 5 | 0 |
310130 | 310130 | 2020-07-07 | Lane | Kansas | 20101 | 5 | 0 |
313300 | 313300 | 2020-07-08 | Lane | Kansas | 20101 | 5 | 0 |
316474 | 316474 | 2020-07-09 | Lane | Kansas | 20101 | 5 | 0 |
319647 | 319647 | 2020-07-10 | Lane | Kansas | 20101 | 5 | 0 |
322826 | 322826 | 2020-07-11 | Lane | Kansas | 20101 | 5 | 0 |
326009 | 326009 | 2020-07-12 | Lane | Kansas | 20101 | 5 | 0 |
329195 | 329195 | 2020-07-13 | Lane | Kansas | 20101 | 5 | 0 |
332382 | 332382 | 2020-07-14 | Lane | Kansas | 20101 | 5 | 0 |
335575 | 335575 | 2020-07-15 | Lane | Kansas | 20101 | 5 | 0 |
338771 | 338771 | 2020-07-16 | Lane | Kansas | 20101 | 5 | 0 |
341967 | 341967 | 2020-07-17 | Lane | Kansas | 20101 | 5 | 0 |
345167 | 345167 | 2020-07-18 | Lane | Kansas | 20101 | 5 | 0 |
348368 | 348368 | 2020-07-19 | Lane | Kansas | 20101 | 5 | 0 |
351568 | 351568 | 2020-07-20 | Lane | Kansas | 20101 | 5 | 0 |
354770 | 354770 | 2020-07-21 | Lane | Kansas | 20101 | 5 | 0 |
357972 | 357972 | 2020-07-22 | Lane | Kansas | 20101 | 5 | 0 |
361177 | 361177 | 2020-07-23 | Lane | Kansas | 20101 | 5 | 0 |
364384 | 364384 | 2020-07-24 | Lane | Kansas | 20101 | 5 | 0 |
367591 | 367591 | 2020-07-25 | Lane | Kansas | 20101 | 5 | 0 |
370801 | 370801 | 2020-07-26 | Lane | Kansas | 20101 | 5 | 0 |
374013 | 374013 | 2020-07-27 | Lane | Kansas | 20101 | 5 | 0 |
377228 | 377228 | 2020-07-28 | Lane | Kansas | 20101 | 5 | 0 |
380445 | 380445 | 2020-07-29 | Lane | Kansas | 20101 | 5 | 0 |
383662 | 383662 | 2020-07-30 | Lane | Kansas | 20101 | 5 | 0 |
386880 | 386880 | 2020-07-31 | Lane | Kansas | 20101 | 5 | 0 |
390097 | 390097 | 2020-08-01 | Lane | Kansas | 20101 | 5 | 0 |
393314 | 393314 | 2020-08-02 | Lane | Kansas | 20101 | 5 | 0 |
396530 | 396530 | 2020-08-03 | Lane | Kansas | 20101 | 5 | 0 |
399745 | 399745 | 2020-08-04 | Lane | Kansas | 20101 | 5 | 0 |
402962 | 402962 | 2020-08-05 | Lane | Kansas | 20101 | 5 | 0 |
406180 | 406180 | 2020-08-06 | Lane | Kansas | 20101 | 5 | 0 |
409399 | 409399 | 2020-08-07 | Lane | Kansas | 20101 | 5 | 0 |
412619 | 412619 | 2020-08-08 | Lane | Kansas | 20101 | 5 | 0 |
415839 | 415839 | 2020-08-09 | Lane | Kansas | 20101 | 5 | 0 |
419060 | 419060 | 2020-08-10 | Lane | Kansas | 20101 | 5 | 0 |
422283 | 422283 | 2020-08-11 | Lane | Kansas | 20101 | 5 | 0 |
425504 | 425504 | 2020-08-12 | Lane | Kansas | 20101 | 5 | 0 |
428728 | 428728 | 2020-08-13 | Lane | Kansas | 20101 | 5 | 0 |
431956 | 431956 | 2020-08-14 | Lane | Kansas | 20101 | 6 | 0 |
435181 | 435181 | 2020-08-15 | Lane | Kansas | 20101 | 6 | 0 |
438406 | 438406 | 2020-08-16 | Lane | Kansas | 20101 | 6 | 0 |
441633 | 441633 | 2020-08-17 | Lane | Kansas | 20101 | 6 | 0 |
444859 | 444859 | 2020-08-18 | Lane | Kansas | 20101 | 6 | 0 |
448086 | 448086 | 2020-08-19 | Lane | Kansas | 20101 | 6 | 0 |
451314 | 451314 | 2020-08-20 | Lane | Kansas | 20101 | 6 | 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);