ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where county = "Jefferson" and state = "Louisiana" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-09 1
- 2020-03-10 1
- 2020-03-11 1
- 2020-03-12 1
- 2020-03-13 1
- 2020-03-14 1
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- …
state 1
- Louisiana · 796 ✖
fips 1
- 22051 796
county 1
- Jefferson · 796 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
924 | 924 | 2020-03-09 | Jefferson | Louisiana | 22051 | 1 | 0 |
1069 | 1069 | 2020-03-10 | Jefferson | Louisiana | 22051 | 1 | 0 |
1248 | 1248 | 2020-03-11 | Jefferson | Louisiana | 22051 | 1 | 0 |
1465 | 1465 | 2020-03-12 | Jefferson | Louisiana | 22051 | 1 | 0 |
1738 | 1738 | 2020-03-13 | Jefferson | Louisiana | 22051 | 3 | 0 |
2076 | 2076 | 2020-03-14 | Jefferson | Louisiana | 22051 | 11 | 0 |
2473 | 2473 | 2020-03-15 | Jefferson | Louisiana | 22051 | 14 | 0 |
2919 | 2919 | 2020-03-16 | Jefferson | Louisiana | 22051 | 21 | 0 |
3416 | 3416 | 2020-03-17 | Jefferson | Louisiana | 22051 | 35 | 0 |
3996 | 3996 | 2020-03-18 | Jefferson | Louisiana | 22051 | 45 | 1 |
4691 | 4691 | 2020-03-19 | Jefferson | Louisiana | 22051 | 69 | 1 |
5507 | 5507 | 2020-03-20 | Jefferson | Louisiana | 22051 | 104 | 1 |
6460 | 6460 | 2020-03-21 | Jefferson | Louisiana | 22051 | 166 | 2 |
7535 | 7535 | 2020-03-22 | Jefferson | Louisiana | 22051 | 184 | 3 |
8700 | 8700 | 2020-03-23 | Jefferson | Louisiana | 22051 | 252 | 5 |
9988 | 9988 | 2020-03-24 | Jefferson | Louisiana | 22051 | 293 | 6 |
11393 | 11393 | 2020-03-25 | Jefferson | Louisiana | 22051 | 359 | 7 |
12969 | 12969 | 2020-03-26 | Jefferson | Louisiana | 22051 | 458 | 12 |
14676 | 14676 | 2020-03-27 | Jefferson | Louisiana | 22051 | 548 | 24 |
16496 | 16496 | 2020-03-28 | Jefferson | Louisiana | 22051 | 744 | 26 |
18408 | 18408 | 2020-03-29 | Jefferson | Louisiana | 22051 | 761 | 28 |
20424 | 20424 | 2020-03-30 | Jefferson | Louisiana | 22051 | 838 | 37 |
22532 | 22532 | 2020-03-31 | Jefferson | Louisiana | 22051 | 1193 | 57 |
24708 | 24708 | 2020-04-01 | Jefferson | Louisiana | 22051 | 1433 | 64 |
26959 | 26959 | 2020-04-02 | Jefferson | Louisiana | 22051 | 2178 | 73 |
29276 | 29276 | 2020-04-03 | Jefferson | Louisiana | 22051 | 2495 | 85 |
31654 | 31654 | 2020-04-04 | Jefferson | Louisiana | 22051 | 3008 | 95 |
34079 | 34079 | 2020-04-05 | Jefferson | Louisiana | 22051 | 3088 | 113 |
36537 | 36537 | 2020-04-06 | Jefferson | Louisiana | 22051 | 3530 | 121 |
39045 | 39045 | 2020-04-07 | Jefferson | Louisiana | 22051 | 3922 | 137 |
41597 | 41597 | 2020-04-08 | Jefferson | Louisiana | 22051 | 4092 | 149 |
44173 | 44173 | 2020-04-09 | Jefferson | Louisiana | 22051 | 4480 | 158 |
46781 | 46781 | 2020-04-10 | Jefferson | Louisiana | 22051 | 4678 | 165 |
49422 | 49422 | 2020-04-11 | Jefferson | Louisiana | 22051 | 4877 | 170 |
52092 | 52092 | 2020-04-12 | Jefferson | Louisiana | 22051 | 4990 | 173 |
54773 | 54773 | 2020-04-13 | Jefferson | Louisiana | 22051 | 5088 | 186 |
57471 | 57471 | 2020-04-14 | Jefferson | Louisiana | 22051 | 5188 | 210 |
60179 | 60179 | 2020-04-15 | Jefferson | Louisiana | 22051 | 5265 | 247 |
62900 | 62900 | 2020-04-16 | Jefferson | Louisiana | 22051 | 5346 | 261 |
65639 | 65639 | 2020-04-17 | Jefferson | Louisiana | 22051 | 5476 | 269 |
68388 | 68388 | 2020-04-18 | Jefferson | Louisiana | 22051 | 5543 | 275 |
71151 | 71151 | 2020-04-19 | Jefferson | Louisiana | 22051 | 5592 | 282 |
73923 | 73923 | 2020-04-20 | Jefferson | Louisiana | 22051 | 5761 | 286 |
76703 | 76703 | 2020-04-21 | Jefferson | Louisiana | 22051 | 5802 | 288 |
79489 | 79489 | 2020-04-22 | Jefferson | Louisiana | 22051 | 5860 | 297 |
82285 | 82285 | 2020-04-23 | Jefferson | Louisiana | 22051 | 5929 | 306 |
85089 | 85089 | 2020-04-24 | Jefferson | Louisiana | 22051 | 5985 | 323 |
87898 | 87898 | 2020-04-25 | Jefferson | Louisiana | 22051 | 6007 | 325 |
90714 | 90714 | 2020-04-26 | Jefferson | Louisiana | 22051 | 6059 | 329 |
93535 | 93535 | 2020-04-27 | Jefferson | Louisiana | 22051 | 6104 | 331 |
96370 | 96370 | 2020-04-28 | Jefferson | Louisiana | 22051 | 6135 | 340 |
99216 | 99216 | 2020-04-29 | Jefferson | Louisiana | 22051 | 6173 | 340 |
102068 | 102068 | 2020-04-30 | Jefferson | Louisiana | 22051 | 6197 | 346 |
104929 | 104929 | 2020-05-01 | Jefferson | Louisiana | 22051 | 6305 | 368 |
107793 | 107793 | 2020-05-02 | Jefferson | Louisiana | 22051 | 6362 | 369 |
110665 | 110665 | 2020-05-03 | Jefferson | Louisiana | 22051 | 6388 | 371 |
113542 | 113542 | 2020-05-04 | Jefferson | Louisiana | 22051 | 6426 | 377 |
116424 | 116424 | 2020-05-05 | Jefferson | Louisiana | 22051 | 6491 | 381 |
119385 | 119385 | 2020-05-06 | Jefferson | Louisiana | 22051 | 6554 | 387 |
122356 | 122356 | 2020-05-07 | Jefferson | Louisiana | 22051 | 6588 | 391 |
125338 | 125338 | 2020-05-08 | Jefferson | Louisiana | 22051 | 6610 | 392 |
128325 | 128325 | 2020-05-09 | Jefferson | Louisiana | 22051 | 6679 | 396 |
131315 | 131315 | 2020-05-10 | Jefferson | Louisiana | 22051 | 6709 | 397 |
134306 | 134306 | 2020-05-11 | Jefferson | Louisiana | 22051 | 6755 | 402 |
137296 | 137296 | 2020-05-12 | Jefferson | Louisiana | 22051 | 6789 | 405 |
140290 | 140290 | 2020-05-13 | Jefferson | Louisiana | 22051 | 6833 | 408 |
143285 | 143285 | 2020-05-14 | Jefferson | Louisiana | 22051 | 6860 | 423 |
146285 | 146285 | 2020-05-15 | Jefferson | Louisiana | 22051 | 6897 | 424 |
149290 | 149290 | 2020-05-16 | Jefferson | Louisiana | 22051 | 6982 | 427 |
152301 | 152301 | 2020-05-17 | Jefferson | Louisiana | 22051 | 7039 | 430 |
155315 | 155315 | 2020-05-18 | Jefferson | Louisiana | 22051 | 7059 | 430 |
158333 | 158333 | 2020-05-19 | Jefferson | Louisiana | 22051 | 7095 | 429 |
161359 | 161359 | 2020-05-20 | Jefferson | Louisiana | 22051 | 7128 | 431 |
164388 | 164388 | 2020-05-21 | Jefferson | Louisiana | 22051 | 7175 | 432 |
167424 | 167424 | 2020-05-22 | Jefferson | Louisiana | 22051 | 7232 | 432 |
170462 | 170462 | 2020-05-23 | Jefferson | Louisiana | 22051 | 7233 | 432 |
173503 | 173503 | 2020-05-24 | Jefferson | Louisiana | 22051 | 7248 | 432 |
176547 | 176547 | 2020-05-25 | Jefferson | Louisiana | 22051 | 7298 | 432 |
179591 | 179591 | 2020-05-26 | Jefferson | Louisiana | 22051 | 7332 | 438 |
182636 | 182636 | 2020-05-27 | Jefferson | Louisiana | 22051 | 7394 | 438 |
185691 | 185691 | 2020-05-28 | Jefferson | Louisiana | 22051 | 7424 | 441 |
188749 | 188749 | 2020-05-29 | Jefferson | Louisiana | 22051 | 7424 | 446 |
191813 | 191813 | 2020-05-30 | Jefferson | Louisiana | 22051 | 7536 | 447 |
194881 | 194881 | 2020-05-31 | Jefferson | Louisiana | 22051 | 7584 | 450 |
197952 | 197952 | 2020-06-01 | Jefferson | Louisiana | 22051 | 7652 | 451 |
201024 | 201024 | 2020-06-02 | Jefferson | Louisiana | 22051 | 7711 | 453 |
204101 | 204101 | 2020-06-03 | Jefferson | Louisiana | 22051 | 7738 | 454 |
207182 | 207182 | 2020-06-04 | Jefferson | Louisiana | 22051 | 7763 | 455 |
210263 | 210263 | 2020-06-05 | Jefferson | Louisiana | 22051 | 7803 | 457 |
213348 | 213348 | 2020-06-06 | Jefferson | Louisiana | 22051 | 7831 | 458 |
216435 | 216435 | 2020-06-07 | Jefferson | Louisiana | 22051 | 7862 | 459 |
219527 | 219527 | 2020-06-08 | Jefferson | Louisiana | 22051 | 7885 | 462 |
222622 | 222622 | 2020-06-09 | Jefferson | Louisiana | 22051 | 7940 | 462 |
225718 | 225718 | 2020-06-10 | Jefferson | Louisiana | 22051 | 7971 | 463 |
228820 | 228820 | 2020-06-11 | Jefferson | Louisiana | 22051 | 8032 | 464 |
231924 | 231924 | 2020-06-12 | Jefferson | Louisiana | 22051 | 8091 | 465 |
235029 | 235029 | 2020-06-13 | Jefferson | Louisiana | 22051 | 8339 | 465 |
238136 | 238136 | 2020-06-14 | Jefferson | Louisiana | 22051 | 8379 | 466 |
241245 | 241245 | 2020-06-15 | Jefferson | Louisiana | 22051 | 8416 | 467 |
244356 | 244356 | 2020-06-16 | Jefferson | Louisiana | 22051 | 8468 | 471 |
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);