ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "St. James" and state = "Louisiana" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
4699 | 4699 | 2020-03-19 | St. James | Louisiana | 22093 | 1 | 1 |
5516 | 5516 | 2020-03-20 | St. James | Louisiana | 22093 | 1 | 1 |
6470 | 6470 | 2020-03-21 | St. James | Louisiana | 22093 | 1 | 1 |
7545 | 7545 | 2020-03-22 | St. James | Louisiana | 22093 | 1 | 1 |
8713 | 8713 | 2020-03-23 | St. James | Louisiana | 22093 | 8 | 1 |
10001 | 10001 | 2020-03-24 | St. James | Louisiana | 22093 | 9 | 1 |
11408 | 11408 | 2020-03-25 | St. James | Louisiana | 22093 | 14 | 1 |
12987 | 12987 | 2020-03-26 | St. James | Louisiana | 22093 | 29 | 1 |
14694 | 14694 | 2020-03-27 | St. James | Louisiana | 22093 | 40 | 3 |
16514 | 16514 | 2020-03-28 | St. James | Louisiana | 22093 | 48 | 3 |
18428 | 18428 | 2020-03-29 | St. James | Louisiana | 22093 | 55 | 3 |
20444 | 20444 | 2020-03-30 | St. James | Louisiana | 22093 | 65 | 3 |
22553 | 22553 | 2020-03-31 | St. James | Louisiana | 22093 | 77 | 4 |
24729 | 24729 | 2020-04-01 | St. James | Louisiana | 22093 | 86 | 4 |
26980 | 26980 | 2020-04-02 | St. James | Louisiana | 22093 | 110 | 4 |
29297 | 29297 | 2020-04-03 | St. James | Louisiana | 22093 | 116 | 4 |
31675 | 31675 | 2020-04-04 | St. James | Louisiana | 22093 | 150 | 6 |
34100 | 34100 | 2020-04-05 | St. James | Louisiana | 22093 | 155 | 6 |
36558 | 36558 | 2020-04-06 | St. James | Louisiana | 22093 | 167 | 6 |
39066 | 39066 | 2020-04-07 | St. James | Louisiana | 22093 | 176 | 6 |
41618 | 41618 | 2020-04-08 | St. James | Louisiana | 22093 | 181 | 7 |
44194 | 44194 | 2020-04-09 | St. James | Louisiana | 22093 | 191 | 7 |
46802 | 46802 | 2020-04-10 | St. James | Louisiana | 22093 | 194 | 9 |
49443 | 49443 | 2020-04-11 | St. James | Louisiana | 22093 | 197 | 9 |
52113 | 52113 | 2020-04-12 | St. James | Louisiana | 22093 | 204 | 10 |
54794 | 54794 | 2020-04-13 | St. James | Louisiana | 22093 | 207 | 11 |
57492 | 57492 | 2020-04-14 | St. James | Louisiana | 22093 | 208 | 13 |
60200 | 60200 | 2020-04-15 | St. James | Louisiana | 22093 | 210 | 13 |
62921 | 62921 | 2020-04-16 | St. James | Louisiana | 22093 | 214 | 14 |
65660 | 65660 | 2020-04-17 | St. James | Louisiana | 22093 | 216 | 14 |
68409 | 68409 | 2020-04-18 | St. James | Louisiana | 22093 | 217 | 14 |
71172 | 71172 | 2020-04-19 | St. James | Louisiana | 22093 | 218 | 15 |
73944 | 73944 | 2020-04-20 | St. James | Louisiana | 22093 | 222 | 15 |
76724 | 76724 | 2020-04-21 | St. James | Louisiana | 22093 | 228 | 16 |
82306 | 82306 | 2020-04-23 | St. James | Louisiana | 22093 | 235 | 17 |
79510 | 79510 | 2020-04-22 | St. James | Louisiana | 22093 | 231 | 18 |
87919 | 87919 | 2020-04-25 | St. James | Louisiana | 22093 | 237 | 18 |
90735 | 90735 | 2020-04-26 | St. James | Louisiana | 22093 | 239 | 18 |
93556 | 93556 | 2020-04-27 | St. James | Louisiana | 22093 | 239 | 18 |
85110 | 85110 | 2020-04-24 | St. James | Louisiana | 22093 | 237 | 19 |
96391 | 96391 | 2020-04-28 | St. James | Louisiana | 22093 | 240 | 19 |
99237 | 99237 | 2020-04-29 | St. James | Louisiana | 22093 | 243 | 19 |
102089 | 102089 | 2020-04-30 | St. James | Louisiana | 22093 | 246 | 19 |
104950 | 104950 | 2020-05-01 | St. James | Louisiana | 22093 | 247 | 19 |
107814 | 107814 | 2020-05-02 | St. James | Louisiana | 22093 | 247 | 19 |
110686 | 110686 | 2020-05-03 | St. James | Louisiana | 22093 | 250 | 20 |
113563 | 113563 | 2020-05-04 | St. James | Louisiana | 22093 | 253 | 20 |
116445 | 116445 | 2020-05-05 | St. James | Louisiana | 22093 | 254 | 20 |
119406 | 119406 | 2020-05-06 | St. James | Louisiana | 22093 | 256 | 20 |
122377 | 122377 | 2020-05-07 | St. James | Louisiana | 22093 | 256 | 20 |
125359 | 125359 | 2020-05-08 | St. James | Louisiana | 22093 | 257 | 20 |
128346 | 128346 | 2020-05-09 | St. James | Louisiana | 22093 | 257 | 20 |
131336 | 131336 | 2020-05-10 | St. James | Louisiana | 22093 | 257 | 20 |
134327 | 134327 | 2020-05-11 | St. James | Louisiana | 22093 | 256 | 20 |
137317 | 137317 | 2020-05-12 | St. James | Louisiana | 22093 | 256 | 20 |
140311 | 140311 | 2020-05-13 | St. James | Louisiana | 22093 | 268 | 22 |
143306 | 143306 | 2020-05-14 | St. James | Louisiana | 22093 | 284 | 22 |
146306 | 146306 | 2020-05-15 | St. James | Louisiana | 22093 | 284 | 23 |
149311 | 149311 | 2020-05-16 | St. James | Louisiana | 22093 | 282 | 23 |
152322 | 152322 | 2020-05-17 | St. James | Louisiana | 22093 | 283 | 23 |
155336 | 155336 | 2020-05-18 | St. James | Louisiana | 22093 | 284 | 23 |
158354 | 158354 | 2020-05-19 | St. James | Louisiana | 22093 | 284 | 23 |
161380 | 161380 | 2020-05-20 | St. James | Louisiana | 22093 | 284 | 23 |
164409 | 164409 | 2020-05-21 | St. James | Louisiana | 22093 | 289 | 24 |
167445 | 167445 | 2020-05-22 | St. James | Louisiana | 22093 | 289 | 25 |
170483 | 170483 | 2020-05-23 | St. James | Louisiana | 22093 | 289 | 25 |
173524 | 173524 | 2020-05-24 | St. James | Louisiana | 22093 | 289 | 25 |
176568 | 176568 | 2020-05-25 | St. James | Louisiana | 22093 | 292 | 25 |
179612 | 179612 | 2020-05-26 | St. James | Louisiana | 22093 | 292 | 25 |
182657 | 182657 | 2020-05-27 | St. James | Louisiana | 22093 | 293 | 25 |
185712 | 185712 | 2020-05-28 | St. James | Louisiana | 22093 | 294 | 25 |
188770 | 188770 | 2020-05-29 | St. James | Louisiana | 22093 | 294 | 25 |
191834 | 191834 | 2020-05-30 | St. James | Louisiana | 22093 | 294 | 25 |
194902 | 194902 | 2020-05-31 | St. James | Louisiana | 22093 | 294 | 25 |
197973 | 197973 | 2020-06-01 | St. James | Louisiana | 22093 | 294 | 25 |
201045 | 201045 | 2020-06-02 | St. James | Louisiana | 22093 | 294 | 27 |
204122 | 204122 | 2020-06-03 | St. James | Louisiana | 22093 | 303 | 27 |
207203 | 207203 | 2020-06-04 | St. James | Louisiana | 22093 | 303 | 27 |
210284 | 210284 | 2020-06-05 | St. James | Louisiana | 22093 | 304 | 27 |
213369 | 213369 | 2020-06-06 | St. James | Louisiana | 22093 | 304 | 27 |
216456 | 216456 | 2020-06-07 | St. James | Louisiana | 22093 | 304 | 27 |
219548 | 219548 | 2020-06-08 | St. James | Louisiana | 22093 | 304 | 27 |
222643 | 222643 | 2020-06-09 | St. James | Louisiana | 22093 | 305 | 27 |
225739 | 225739 | 2020-06-10 | St. James | Louisiana | 22093 | 306 | 27 |
228841 | 228841 | 2020-06-11 | St. James | Louisiana | 22093 | 306 | 27 |
231945 | 231945 | 2020-06-12 | St. James | Louisiana | 22093 | 308 | 27 |
235050 | 235050 | 2020-06-13 | St. James | Louisiana | 22093 | 308 | 27 |
238157 | 238157 | 2020-06-14 | St. James | Louisiana | 22093 | 308 | 27 |
241266 | 241266 | 2020-06-15 | St. James | Louisiana | 22093 | 308 | 27 |
244377 | 244377 | 2020-06-16 | St. James | Louisiana | 22093 | 309 | 27 |
247490 | 247490 | 2020-06-17 | St. James | Louisiana | 22093 | 313 | 28 |
250602 | 250602 | 2020-06-18 | St. James | Louisiana | 22093 | 313 | 28 |
253717 | 253717 | 2020-06-19 | St. James | Louisiana | 22093 | 331 | 28 |
256837 | 256837 | 2020-06-20 | St. James | Louisiana | 22093 | 333 | 28 |
259963 | 259963 | 2020-06-21 | St. James | Louisiana | 22093 | 334 | 28 |
263092 | 263092 | 2020-06-22 | St. James | Louisiana | 22093 | 334 | 28 |
266219 | 266219 | 2020-06-23 | St. James | Louisiana | 22093 | 338 | 28 |
269352 | 269352 | 2020-06-24 | St. James | Louisiana | 22093 | 338 | 28 |
272488 | 272488 | 2020-06-25 | St. James | Louisiana | 22093 | 340 | 28 |
275631 | 275631 | 2020-06-26 | St. James | Louisiana | 22093 | 345 | 28 |
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);