ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Morehouse" and state = "Louisiana" 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 |
---|---|---|---|---|---|---|---|
11399 | 11399 | 2020-03-25 | Morehouse | Louisiana | 22067 | 1 | 0 |
14684 | 14684 | 2020-03-27 | Morehouse | Louisiana | 22067 | 2 | 0 |
16504 | 16504 | 2020-03-28 | Morehouse | Louisiana | 22067 | 2 | 0 |
18416 | 18416 | 2020-03-29 | Morehouse | Louisiana | 22067 | 2 | 0 |
20432 | 20432 | 2020-03-30 | Morehouse | Louisiana | 22067 | 2 | 0 |
22540 | 22540 | 2020-03-31 | Morehouse | Louisiana | 22067 | 2 | 0 |
24716 | 24716 | 2020-04-01 | Morehouse | Louisiana | 22067 | 2 | 0 |
12977 | 12977 | 2020-03-26 | Morehouse | Louisiana | 22067 | 3 | 0 |
26967 | 26967 | 2020-04-02 | Morehouse | Louisiana | 22067 | 4 | 0 |
29284 | 29284 | 2020-04-03 | Morehouse | Louisiana | 22067 | 7 | 0 |
31662 | 31662 | 2020-04-04 | Morehouse | Louisiana | 22067 | 9 | 0 |
34087 | 34087 | 2020-04-05 | Morehouse | Louisiana | 22067 | 10 | 0 |
36545 | 36545 | 2020-04-06 | Morehouse | Louisiana | 22067 | 15 | 0 |
39053 | 39053 | 2020-04-07 | Morehouse | Louisiana | 22067 | 20 | 0 |
41605 | 41605 | 2020-04-08 | Morehouse | Louisiana | 22067 | 23 | 0 |
44181 | 44181 | 2020-04-09 | Morehouse | Louisiana | 22067 | 24 | 0 |
46789 | 46789 | 2020-04-10 | Morehouse | Louisiana | 22067 | 27 | 2 |
49430 | 49430 | 2020-04-11 | Morehouse | Louisiana | 22067 | 31 | 2 |
52100 | 52100 | 2020-04-12 | Morehouse | Louisiana | 22067 | 31 | 2 |
54781 | 54781 | 2020-04-13 | Morehouse | Louisiana | 22067 | 32 | 2 |
57479 | 57479 | 2020-04-14 | Morehouse | Louisiana | 22067 | 32 | 2 |
60187 | 60187 | 2020-04-15 | Morehouse | Louisiana | 22067 | 32 | 2 |
62908 | 62908 | 2020-04-16 | Morehouse | Louisiana | 22067 | 34 | 2 |
65647 | 65647 | 2020-04-17 | Morehouse | Louisiana | 22067 | 34 | 2 |
68396 | 68396 | 2020-04-18 | Morehouse | Louisiana | 22067 | 35 | 2 |
71159 | 71159 | 2020-04-19 | Morehouse | Louisiana | 22067 | 37 | 3 |
73931 | 73931 | 2020-04-20 | Morehouse | Louisiana | 22067 | 38 | 3 |
76711 | 76711 | 2020-04-21 | Morehouse | Louisiana | 22067 | 39 | 4 |
79497 | 79497 | 2020-04-22 | Morehouse | Louisiana | 22067 | 41 | 4 |
82293 | 82293 | 2020-04-23 | Morehouse | Louisiana | 22067 | 45 | 4 |
85097 | 85097 | 2020-04-24 | Morehouse | Louisiana | 22067 | 46 | 4 |
87906 | 87906 | 2020-04-25 | Morehouse | Louisiana | 22067 | 46 | 4 |
90722 | 90722 | 2020-04-26 | Morehouse | Louisiana | 22067 | 46 | 4 |
93543 | 93543 | 2020-04-27 | Morehouse | Louisiana | 22067 | 48 | 4 |
96378 | 96378 | 2020-04-28 | Morehouse | Louisiana | 22067 | 48 | 4 |
99224 | 99224 | 2020-04-29 | Morehouse | Louisiana | 22067 | 51 | 4 |
102076 | 102076 | 2020-04-30 | Morehouse | Louisiana | 22067 | 52 | 4 |
104937 | 104937 | 2020-05-01 | Morehouse | Louisiana | 22067 | 52 | 4 |
107801 | 107801 | 2020-05-02 | Morehouse | Louisiana | 22067 | 54 | 4 |
110673 | 110673 | 2020-05-03 | Morehouse | Louisiana | 22067 | 55 | 4 |
113550 | 113550 | 2020-05-04 | Morehouse | Louisiana | 22067 | 55 | 4 |
116432 | 116432 | 2020-05-05 | Morehouse | Louisiana | 22067 | 55 | 4 |
119393 | 119393 | 2020-05-06 | Morehouse | Louisiana | 22067 | 55 | 4 |
122364 | 122364 | 2020-05-07 | Morehouse | Louisiana | 22067 | 57 | 5 |
125346 | 125346 | 2020-05-08 | Morehouse | Louisiana | 22067 | 57 | 5 |
128333 | 128333 | 2020-05-09 | Morehouse | Louisiana | 22067 | 60 | 5 |
131323 | 131323 | 2020-05-10 | Morehouse | Louisiana | 22067 | 62 | 5 |
134314 | 134314 | 2020-05-11 | Morehouse | Louisiana | 22067 | 65 | 5 |
137304 | 137304 | 2020-05-12 | Morehouse | Louisiana | 22067 | 67 | 5 |
149298 | 149298 | 2020-05-16 | Morehouse | Louisiana | 22067 | 85 | 5 |
140298 | 140298 | 2020-05-13 | Morehouse | Louisiana | 22067 | 87 | 5 |
143293 | 143293 | 2020-05-14 | Morehouse | Louisiana | 22067 | 89 | 5 |
152309 | 152309 | 2020-05-17 | Morehouse | Louisiana | 22067 | 91 | 5 |
146293 | 146293 | 2020-05-15 | Morehouse | Louisiana | 22067 | 92 | 5 |
155323 | 155323 | 2020-05-18 | Morehouse | Louisiana | 22067 | 93 | 5 |
158341 | 158341 | 2020-05-19 | Morehouse | Louisiana | 22067 | 93 | 5 |
161367 | 161367 | 2020-05-20 | Morehouse | Louisiana | 22067 | 94 | 5 |
164396 | 164396 | 2020-05-21 | Morehouse | Louisiana | 22067 | 108 | 5 |
167432 | 167432 | 2020-05-22 | Morehouse | Louisiana | 22067 | 110 | 5 |
170470 | 170470 | 2020-05-23 | Morehouse | Louisiana | 22067 | 110 | 5 |
173511 | 173511 | 2020-05-24 | Morehouse | Louisiana | 22067 | 111 | 5 |
176555 | 176555 | 2020-05-25 | Morehouse | Louisiana | 22067 | 117 | 5 |
179599 | 179599 | 2020-05-26 | Morehouse | Louisiana | 22067 | 119 | 5 |
182644 | 182644 | 2020-05-27 | Morehouse | Louisiana | 22067 | 121 | 5 |
185699 | 185699 | 2020-05-28 | Morehouse | Louisiana | 22067 | 121 | 5 |
188757 | 188757 | 2020-05-29 | Morehouse | Louisiana | 22067 | 121 | 5 |
191821 | 191821 | 2020-05-30 | Morehouse | Louisiana | 22067 | 121 | 5 |
194889 | 194889 | 2020-05-31 | Morehouse | Louisiana | 22067 | 122 | 5 |
197960 | 197960 | 2020-06-01 | Morehouse | Louisiana | 22067 | 122 | 5 |
201032 | 201032 | 2020-06-02 | Morehouse | Louisiana | 22067 | 122 | 5 |
204109 | 204109 | 2020-06-03 | Morehouse | Louisiana | 22067 | 131 | 5 |
207190 | 207190 | 2020-06-04 | Morehouse | Louisiana | 22067 | 132 | 5 |
210271 | 210271 | 2020-06-05 | Morehouse | Louisiana | 22067 | 132 | 5 |
213356 | 213356 | 2020-06-06 | Morehouse | Louisiana | 22067 | 133 | 5 |
216443 | 216443 | 2020-06-07 | Morehouse | Louisiana | 22067 | 133 | 5 |
219535 | 219535 | 2020-06-08 | Morehouse | Louisiana | 22067 | 134 | 5 |
222630 | 222630 | 2020-06-09 | Morehouse | Louisiana | 22067 | 135 | 5 |
225726 | 225726 | 2020-06-10 | Morehouse | Louisiana | 22067 | 136 | 6 |
228828 | 228828 | 2020-06-11 | Morehouse | Louisiana | 22067 | 138 | 6 |
231932 | 231932 | 2020-06-12 | Morehouse | Louisiana | 22067 | 138 | 6 |
235037 | 235037 | 2020-06-13 | Morehouse | Louisiana | 22067 | 153 | 6 |
238144 | 238144 | 2020-06-14 | Morehouse | Louisiana | 22067 | 158 | 6 |
241253 | 241253 | 2020-06-15 | Morehouse | Louisiana | 22067 | 161 | 6 |
244364 | 244364 | 2020-06-16 | Morehouse | Louisiana | 22067 | 165 | 6 |
253704 | 253704 | 2020-06-19 | Morehouse | Louisiana | 22067 | 182 | 6 |
256824 | 256824 | 2020-06-20 | Morehouse | Louisiana | 22067 | 182 | 6 |
247477 | 247477 | 2020-06-17 | Morehouse | Louisiana | 22067 | 186 | 6 |
250589 | 250589 | 2020-06-18 | Morehouse | Louisiana | 22067 | 186 | 6 |
259950 | 259950 | 2020-06-21 | Morehouse | Louisiana | 22067 | 186 | 6 |
263079 | 263079 | 2020-06-22 | Morehouse | Louisiana | 22067 | 188 | 7 |
266206 | 266206 | 2020-06-23 | Morehouse | Louisiana | 22067 | 213 | 7 |
269339 | 269339 | 2020-06-24 | Morehouse | Louisiana | 22067 | 216 | 7 |
272475 | 272475 | 2020-06-25 | Morehouse | Louisiana | 22067 | 218 | 7 |
275618 | 275618 | 2020-06-26 | Morehouse | Louisiana | 22067 | 227 | 8 |
278766 | 278766 | 2020-06-27 | Morehouse | Louisiana | 22067 | 227 | 8 |
288209 | 288209 | 2020-06-30 | Morehouse | Louisiana | 22067 | 235 | 8 |
281914 | 281914 | 2020-06-28 | Morehouse | Louisiana | 22067 | 236 | 8 |
285060 | 285060 | 2020-06-29 | Morehouse | Louisiana | 22067 | 237 | 8 |
291360 | 291360 | 2020-07-01 | Morehouse | Louisiana | 22067 | 239 | 8 |
294514 | 294514 | 2020-07-02 | Morehouse | Louisiana | 22067 | 242 | 9 |
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);