ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Unknown" and state = "Louisiana" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
4004 | 4004 | 2020-03-18 | Unknown | Louisiana | 2 | 0 | |
4704 | 4704 | 2020-03-19 | Unknown | Louisiana | 3 | 0 | |
5522 | 5522 | 2020-03-20 | Unknown | Louisiana | 5 | 0 | |
18437 | 18437 | 2020-03-29 | Unknown | Louisiana | 8 | 1 | |
6477 | 6477 | 2020-03-21 | Unknown | Louisiana | 9 | 0 | |
11417 | 11417 | 2020-03-25 | Unknown | Louisiana | 9 | 1 | |
16523 | 16523 | 2020-03-28 | Unknown | Louisiana | 9 | 1 | |
10009 | 10009 | 2020-03-24 | Unknown | Louisiana | 10 | 1 | |
7552 | 7552 | 2020-03-22 | Unknown | Louisiana | 11 | 0 | |
8721 | 8721 | 2020-03-23 | Unknown | Louisiana | 12 | 0 | |
12996 | 12996 | 2020-03-26 | Unknown | Louisiana | 12 | 1 | |
20453 | 20453 | 2020-03-30 | Unknown | Louisiana | 14 | 0 | |
14703 | 14703 | 2020-03-27 | Unknown | Louisiana | 16 | 1 | |
22562 | 22562 | 2020-03-31 | Unknown | Louisiana | 22 | 4 | |
24738 | 24738 | 2020-04-01 | Unknown | Louisiana | 28 | 0 | |
31684 | 31684 | 2020-04-04 | Unknown | Louisiana | 35 | 0 | |
34109 | 34109 | 2020-04-05 | Unknown | Louisiana | 35 | 4 | |
26989 | 26989 | 2020-04-02 | Unknown | Louisiana | 40 | 1 | |
29306 | 29306 | 2020-04-03 | Unknown | Louisiana | 42 | 4 | |
36567 | 36567 | 2020-04-06 | Unknown | Louisiana | 48 | 3 | |
39075 | 39075 | 2020-04-07 | Unknown | Louisiana | 49 | 2 | |
41627 | 41627 | 2020-04-08 | Unknown | Louisiana | 49 | 2 | |
44203 | 44203 | 2020-04-09 | Unknown | Louisiana | 51 | 2 | |
46811 | 46811 | 2020-04-10 | Unknown | Louisiana | 54 | 2 | |
49453 | 49453 | 2020-04-11 | Unknown | Louisiana | 54 | 3 | |
52123 | 52123 | 2020-04-12 | Unknown | Louisiana | 54 | 3 | |
54804 | 54804 | 2020-04-13 | Unknown | Louisiana | 56 | 0 | |
57502 | 57502 | 2020-04-14 | Unknown | Louisiana | 56 | 0 | |
60210 | 60210 | 2020-04-15 | Unknown | Louisiana | 56 | 1 | |
62931 | 62931 | 2020-04-16 | Unknown | Louisiana | 56 | 1 | |
65670 | 65670 | 2020-04-17 | Unknown | Louisiana | 56 | 1 | |
68419 | 68419 | 2020-04-18 | Unknown | Louisiana | 57 | 1 | |
71182 | 71182 | 2020-04-19 | Unknown | Louisiana | 58 | 1 | |
73954 | 73954 | 2020-04-20 | Unknown | Louisiana | 59 | 1 | |
76734 | 76734 | 2020-04-21 | Unknown | Louisiana | 59 | 2 | |
96401 | 96401 | 2020-04-28 | Unknown | Louisiana | 104 | 43 | |
99247 | 99247 | 2020-04-29 | Unknown | Louisiana | 104 | 43 | |
102099 | 102099 | 2020-04-30 | Unknown | Louisiana | 104 | 43 | |
104960 | 104960 | 2020-05-01 | Unknown | Louisiana | 106 | 43 | |
107824 | 107824 | 2020-05-02 | Unknown | Louisiana | 106 | 43 | |
110696 | 110696 | 2020-05-03 | Unknown | Louisiana | 106 | 43 | |
93566 | 93566 | 2020-04-27 | Unknown | Louisiana | 107 | 43 | |
313526 | 313526 | 2020-07-08 | Unknown | Louisiana | 108 | 108 | |
316700 | 316700 | 2020-07-09 | Unknown | Louisiana | 108 | 108 | |
332610 | 332610 | 2020-07-14 | Unknown | Louisiana | 108 | 108 | |
288232 | 288232 | 2020-06-30 | Unknown | Louisiana | 110 | 108 | |
319875 | 319875 | 2020-07-10 | Unknown | Louisiana | 110 | 108 | |
291383 | 291383 | 2020-07-01 | Unknown | Louisiana | 111 | 108 | |
323054 | 323054 | 2020-07-11 | Unknown | Louisiana | 112 | 108 | |
326237 | 326237 | 2020-07-12 | Unknown | Louisiana | 112 | 108 | |
335803 | 335803 | 2020-07-15 | Unknown | Louisiana | 112 | 110 | |
294537 | 294537 | 2020-07-02 | Unknown | Louisiana | 113 | 108 | |
338999 | 338999 | 2020-07-16 | Unknown | Louisiana | 113 | 110 | |
342195 | 342195 | 2020-07-17 | Unknown | Louisiana | 114 | 110 | |
345395 | 345395 | 2020-07-18 | Unknown | Louisiana | 114 | 110 | |
297695 | 297695 | 2020-07-03 | Unknown | Louisiana | 115 | 108 | |
300857 | 300857 | 2020-07-04 | Unknown | Louisiana | 115 | 108 | |
329423 | 329423 | 2020-07-13 | Unknown | Louisiana | 115 | 108 | |
348596 | 348596 | 2020-07-19 | Unknown | Louisiana | 115 | 110 | |
304021 | 304021 | 2020-07-05 | Unknown | Louisiana | 116 | 108 | |
307188 | 307188 | 2020-07-06 | Unknown | Louisiana | 116 | 108 | |
354998 | 354998 | 2020-07-21 | Unknown | Louisiana | 116 | 110 | |
351796 | 351796 | 2020-07-20 | Unknown | Louisiana | 118 | 110 | |
79520 | 79520 | 2020-04-22 | Unknown | Louisiana | 119 | 60 | |
253727 | 253727 | 2020-06-19 | Unknown | Louisiana | 119 | 112 | |
285083 | 285083 | 2020-06-29 | Unknown | Louisiana | 119 | 108 | |
256847 | 256847 | 2020-06-20 | Unknown | Louisiana | 120 | 112 | |
259973 | 259973 | 2020-06-21 | Unknown | Louisiana | 120 | 112 | |
82316 | 82316 | 2020-04-23 | Unknown | Louisiana | 121 | 59 | |
263102 | 263102 | 2020-06-22 | Unknown | Louisiana | 121 | 113 | |
266229 | 266229 | 2020-06-23 | Unknown | Louisiana | 121 | 113 | |
269362 | 269362 | 2020-06-24 | Unknown | Louisiana | 121 | 113 | |
358201 | 358201 | 2020-07-22 | Unknown | Louisiana | 121 | 112 | |
361406 | 361406 | 2020-07-23 | Unknown | Louisiana | 121 | 112 | |
85120 | 85120 | 2020-04-24 | Unknown | Louisiana | 122 | 59 | |
87929 | 87929 | 2020-04-25 | Unknown | Louisiana | 122 | 59 | |
364613 | 364613 | 2020-07-24 | Unknown | Louisiana | 122 | 112 | |
367820 | 367820 | 2020-07-25 | Unknown | Louisiana | 122 | 112 | |
371030 | 371030 | 2020-07-26 | Unknown | Louisiana | 122 | 112 | |
374242 | 374242 | 2020-07-27 | Unknown | Louisiana | 122 | 112 | |
377457 | 377457 | 2020-07-28 | Unknown | Louisiana | 122 | 112 | |
90745 | 90745 | 2020-04-26 | Unknown | Louisiana | 123 | 59 | |
272498 | 272498 | 2020-06-25 | Unknown | Louisiana | 123 | 113 | |
275641 | 275641 | 2020-06-26 | Unknown | Louisiana | 124 | 113 | |
278789 | 278789 | 2020-06-27 | Unknown | Louisiana | 124 | 113 | |
281937 | 281937 | 2020-06-28 | Unknown | Louisiana | 124 | 113 | |
380674 | 380674 | 2020-07-29 | Unknown | Louisiana | 124 | 114 | |
383891 | 383891 | 2020-07-30 | Unknown | Louisiana | 124 | 114 | |
387109 | 387109 | 2020-07-31 | Unknown | Louisiana | 124 | 114 | |
390326 | 390326 | 2020-08-01 | Unknown | Louisiana | 124 | 114 | |
393543 | 393543 | 2020-08-02 | Unknown | Louisiana | 125 | 114 | |
396759 | 396759 | 2020-08-03 | Unknown | Louisiana | 125 | 114 | |
134337 | 134337 | 2020-05-11 | Unknown | Louisiana | 130 | 68 | |
137327 | 137327 | 2020-05-12 | Unknown | Louisiana | 130 | 67 | |
140321 | 140321 | 2020-05-13 | Unknown | Louisiana | 130 | 66 | |
143316 | 143316 | 2020-05-14 | Unknown | Louisiana | 131 | 66 | |
146316 | 146316 | 2020-05-15 | Unknown | Louisiana | 131 | 66 | |
113573 | 113573 | 2020-05-04 | Unknown | Louisiana | 136 | 73 | |
116455 | 116455 | 2020-05-05 | Unknown | Louisiana | 136 | 73 | |
119416 | 119416 | 2020-05-06 | Unknown | Louisiana | 136 | 74 |
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);