ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,357 rows where county = "Orleans" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 1
- Orleans · 2,357 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
1070 | 1070 | 2020-03-10 | Orleans | Louisiana | 22071 | 5 | 0 |
1249 | 1249 | 2020-03-11 | Orleans | Louisiana | 22071 | 11 | 0 |
1466 | 1466 | 2020-03-12 | Orleans | Louisiana | 22071 | 12 | 0 |
1739 | 1739 | 2020-03-13 | Orleans | Louisiana | 22071 | 28 | 0 |
2078 | 2078 | 2020-03-14 | Orleans | Louisiana | 22071 | 53 | 1 |
2475 | 2475 | 2020-03-15 | Orleans | Louisiana | 22071 | 75 | 2 |
2921 | 2921 | 2020-03-16 | Orleans | Louisiana | 22071 | 95 | 3 |
3418 | 3418 | 2020-03-17 | Orleans | Louisiana | 22071 | 136 | 5 |
3998 | 3998 | 2020-03-18 | Orleans | Louisiana | 22071 | 196 | 6 |
4695 | 4695 | 2020-03-19 | Orleans | Louisiana | 22071 | 252 | 8 |
5511 | 5511 | 2020-03-20 | Orleans | Louisiana | 22071 | 329 | 8 |
6464 | 6464 | 2020-03-21 | Orleans | Louisiana | 22071 | 418 | 13 |
7539 | 7539 | 2020-03-22 | Orleans | Louisiana | 22071 | 451 | 15 |
8706 | 8706 | 2020-03-23 | Orleans | Louisiana | 22071 | 567 | 20 |
9994 | 9994 | 2020-03-24 | Orleans | Louisiana | 22071 | 675 | 26 |
11401 | 11401 | 2020-03-25 | Orleans | Louisiana | 22071 | 827 | 37 |
12979 | 12979 | 2020-03-26 | Orleans | Louisiana | 22071 | 997 | 46 |
14686 | 14686 | 2020-03-27 | Orleans | Louisiana | 22071 | 1170 | 57 |
16506 | 16506 | 2020-03-28 | Orleans | Louisiana | 22071 | 1298 | 70 |
18418 | 18418 | 2020-03-29 | Orleans | Louisiana | 22071 | 1350 | 73 |
20434 | 20434 | 2020-03-30 | Orleans | Louisiana | 22071 | 1480 | 86 |
22542 | 22542 | 2020-03-31 | Orleans | Louisiana | 22071 | 1834 | 101 |
24718 | 24718 | 2020-04-01 | Orleans | Louisiana | 22071 | 2270 | 115 |
26969 | 26969 | 2020-04-02 | Orleans | Louisiana | 22071 | 3148 | 125 |
29286 | 29286 | 2020-04-03 | Orleans | Louisiana | 22071 | 3476 | 148 |
31664 | 31664 | 2020-04-04 | Orleans | Louisiana | 22071 | 3966 | 153 |
34089 | 34089 | 2020-04-05 | Orleans | Louisiana | 22071 | 4066 | 161 |
36547 | 36547 | 2020-04-06 | Orleans | Louisiana | 22071 | 4565 | 171 |
39055 | 39055 | 2020-04-07 | Orleans | Louisiana | 22071 | 4942 | 185 |
41607 | 41607 | 2020-04-08 | Orleans | Louisiana | 22071 | 5070 | 208 |
44183 | 44183 | 2020-04-09 | Orleans | Louisiana | 22071 | 5242 | 224 |
46791 | 46791 | 2020-04-10 | Orleans | Louisiana | 22071 | 5416 | 225 |
49432 | 49432 | 2020-04-11 | Orleans | Louisiana | 22071 | 5535 | 232 |
52102 | 52102 | 2020-04-12 | Orleans | Louisiana | 22071 | 5600 | 235 |
54783 | 54783 | 2020-04-13 | Orleans | Louisiana | 22071 | 5651 | 244 |
57481 | 57481 | 2020-04-14 | Orleans | Louisiana | 22071 | 5718 | 276 |
60189 | 60189 | 2020-04-15 | Orleans | Louisiana | 22071 | 5769 | 287 |
62910 | 62910 | 2020-04-16 | Orleans | Louisiana | 22071 | 5847 | 302 |
65649 | 65649 | 2020-04-17 | Orleans | Louisiana | 22071 | 5906 | 317 |
68398 | 68398 | 2020-04-18 | Orleans | Louisiana | 22071 | 5953 | 324 |
71161 | 71161 | 2020-04-19 | Orleans | Louisiana | 22071 | 6000 | 329 |
73933 | 73933 | 2020-04-20 | Orleans | Louisiana | 22071 | 6148 | 339 |
76713 | 76713 | 2020-04-21 | Orleans | Louisiana | 22071 | 6169 | 344 |
79499 | 79499 | 2020-04-22 | Orleans | Louisiana | 22071 | 6209 | 367 |
82295 | 82295 | 2020-04-23 | Orleans | Louisiana | 22071 | 6263 | 387 |
85099 | 85099 | 2020-04-24 | Orleans | Louisiana | 22071 | 6286 | 392 |
87908 | 87908 | 2020-04-25 | Orleans | Louisiana | 22071 | 6297 | 399 |
90724 | 90724 | 2020-04-26 | Orleans | Louisiana | 22071 | 6342 | 406 |
93545 | 93545 | 2020-04-27 | Orleans | Louisiana | 22071 | 6365 | 406 |
96380 | 96380 | 2020-04-28 | Orleans | Louisiana | 22071 | 6380 | 410 |
99226 | 99226 | 2020-04-29 | Orleans | Louisiana | 22071 | 6420 | 416 |
102078 | 102078 | 2020-04-30 | Orleans | Louisiana | 22071 | 6452 | 434 |
104939 | 104939 | 2020-05-01 | Orleans | Louisiana | 22071 | 6495 | 437 |
107803 | 107803 | 2020-05-02 | Orleans | Louisiana | 22071 | 6524 | 439 |
110675 | 110675 | 2020-05-03 | Orleans | Louisiana | 22071 | 6538 | 441 |
113552 | 113552 | 2020-05-04 | Orleans | Louisiana | 22071 | 6557 | 447 |
116434 | 116434 | 2020-05-05 | Orleans | Louisiana | 22071 | 6575 | 453 |
119395 | 119395 | 2020-05-06 | Orleans | Louisiana | 22071 | 6608 | 464 |
122366 | 122366 | 2020-05-07 | Orleans | Louisiana | 22071 | 6626 | 463 |
125348 | 125348 | 2020-05-08 | Orleans | Louisiana | 22071 | 6645 | 463 |
128335 | 128335 | 2020-05-09 | Orleans | Louisiana | 22071 | 6674 | 468 |
131325 | 131325 | 2020-05-10 | Orleans | Louisiana | 22071 | 6682 | 468 |
134316 | 134316 | 2020-05-11 | Orleans | Louisiana | 22071 | 6693 | 470 |
137306 | 137306 | 2020-05-12 | Orleans | Louisiana | 22071 | 6718 | 477 |
140300 | 140300 | 2020-05-13 | Orleans | Louisiana | 22071 | 6753 | 481 |
143295 | 143295 | 2020-05-14 | Orleans | Louisiana | 22071 | 6768 | 482 |
146295 | 146295 | 2020-05-15 | Orleans | Louisiana | 22071 | 6787 | 489 |
149300 | 149300 | 2020-05-16 | Orleans | Louisiana | 22071 | 6781 | 495 |
152311 | 152311 | 2020-05-17 | Orleans | Louisiana | 22071 | 6809 | 495 |
155325 | 155325 | 2020-05-18 | Orleans | Louisiana | 22071 | 6822 | 495 |
158343 | 158343 | 2020-05-19 | Orleans | Louisiana | 22071 | 6869 | 494 |
161369 | 161369 | 2020-05-20 | Orleans | Louisiana | 22071 | 6884 | 500 |
164398 | 164398 | 2020-05-21 | Orleans | Louisiana | 22071 | 6904 | 500 |
167434 | 167434 | 2020-05-22 | Orleans | Louisiana | 22071 | 6944 | 500 |
170472 | 170472 | 2020-05-23 | Orleans | Louisiana | 22071 | 6949 | 500 |
173513 | 173513 | 2020-05-24 | Orleans | Louisiana | 22071 | 6953 | 500 |
176557 | 176557 | 2020-05-25 | Orleans | Louisiana | 22071 | 7005 | 500 |
179601 | 179601 | 2020-05-26 | Orleans | Louisiana | 22071 | 7021 | 504 |
182646 | 182646 | 2020-05-27 | Orleans | Louisiana | 22071 | 7045 | 504 |
185701 | 185701 | 2020-05-28 | Orleans | Louisiana | 22071 | 7067 | 505 |
188759 | 188759 | 2020-05-29 | Orleans | Louisiana | 22071 | 7067 | 505 |
191823 | 191823 | 2020-05-30 | Orleans | Louisiana | 22071 | 7108 | 507 |
194891 | 194891 | 2020-05-31 | Orleans | Louisiana | 22071 | 7127 | 507 |
197962 | 197962 | 2020-06-01 | Orleans | Louisiana | 22071 | 7141 | 507 |
201034 | 201034 | 2020-06-02 | Orleans | Louisiana | 22071 | 7156 | 506 |
204111 | 204111 | 2020-06-03 | Orleans | Louisiana | 22071 | 7174 | 509 |
207192 | 207192 | 2020-06-04 | Orleans | Louisiana | 22071 | 7192 | 511 |
210273 | 210273 | 2020-06-05 | Orleans | Louisiana | 22071 | 7206 | 511 |
213358 | 213358 | 2020-06-06 | Orleans | Louisiana | 22071 | 7222 | 512 |
216445 | 216445 | 2020-06-07 | Orleans | Louisiana | 22071 | 7230 | 512 |
219537 | 219537 | 2020-06-08 | Orleans | Louisiana | 22071 | 7237 | 512 |
222632 | 222632 | 2020-06-09 | Orleans | Louisiana | 22071 | 7247 | 513 |
225728 | 225728 | 2020-06-10 | Orleans | Louisiana | 22071 | 7279 | 513 |
228830 | 228830 | 2020-06-11 | Orleans | Louisiana | 22071 | 7294 | 515 |
231934 | 231934 | 2020-06-12 | Orleans | Louisiana | 22071 | 7319 | 516 |
235039 | 235039 | 2020-06-13 | Orleans | Louisiana | 22071 | 7374 | 516 |
238146 | 238146 | 2020-06-14 | Orleans | Louisiana | 22071 | 7393 | 518 |
241255 | 241255 | 2020-06-15 | Orleans | Louisiana | 22071 | 7411 | 519 |
244366 | 244366 | 2020-06-16 | Orleans | Louisiana | 22071 | 7428 | 522 |
247479 | 247479 | 2020-06-17 | Orleans | Louisiana | 22071 | 7459 | 523 |
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);