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 rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, 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 |
10329 | 10329 | 2020-03-24 | Orleans | New York | 36073 | 2 | 0 |
10703 | 10703 | 2020-03-24 | Orleans | Vermont | 50019 | 2 | 0 |
11401 | 11401 | 2020-03-25 | Orleans | Louisiana | 22071 | 827 | 37 |
11765 | 11765 | 2020-03-25 | Orleans | New York | 36073 | 2 | 0 |
12215 | 12215 | 2020-03-25 | Orleans | Vermont | 50019 | 3 | 0 |
12979 | 12979 | 2020-03-26 | Orleans | Louisiana | 22071 | 997 | 46 |
13368 | 13368 | 2020-03-26 | Orleans | New York | 36073 | 2 | 0 |
13851 | 13851 | 2020-03-26 | Orleans | Vermont | 50019 | 3 | 0 |
14686 | 14686 | 2020-03-27 | Orleans | Louisiana | 22071 | 1170 | 57 |
15102 | 15102 | 2020-03-27 | Orleans | New York | 36073 | 3 | 0 |
15617 | 15617 | 2020-03-27 | Orleans | Vermont | 50019 | 4 | 0 |
16506 | 16506 | 2020-03-28 | Orleans | Louisiana | 22071 | 1298 | 70 |
16932 | 16932 | 2020-03-28 | Orleans | New York | 36073 | 3 | 0 |
17491 | 17491 | 2020-03-28 | Orleans | Vermont | 50019 | 5 | 0 |
18418 | 18418 | 2020-03-29 | Orleans | Louisiana | 22071 | 1350 | 73 |
18857 | 18857 | 2020-03-29 | Orleans | New York | 36073 | 3 | 0 |
19450 | 19450 | 2020-03-29 | Orleans | Vermont | 50019 | 5 | 0 |
20434 | 20434 | 2020-03-30 | Orleans | Louisiana | 22071 | 1480 | 86 |
20896 | 20896 | 2020-03-30 | Orleans | New York | 36073 | 4 | 0 |
21513 | 21513 | 2020-03-30 | Orleans | Vermont | 50019 | 5 | 0 |
22542 | 22542 | 2020-03-31 | Orleans | Louisiana | 22071 | 1834 | 101 |
23019 | 23019 | 2020-03-31 | Orleans | New York | 36073 | 6 | 0 |
23652 | 23652 | 2020-03-31 | Orleans | Vermont | 50019 | 7 | 0 |
24718 | 24718 | 2020-04-01 | Orleans | Louisiana | 22071 | 2270 | 115 |
25213 | 25213 | 2020-04-01 | Orleans | New York | 36073 | 6 | 0 |
25867 | 25867 | 2020-04-01 | Orleans | Vermont | 50019 | 7 | 0 |
26969 | 26969 | 2020-04-02 | Orleans | Louisiana | 22071 | 3148 | 125 |
27473 | 27473 | 2020-04-02 | Orleans | New York | 36073 | 6 | 0 |
28156 | 28156 | 2020-04-02 | Orleans | Vermont | 50019 | 7 | 0 |
29286 | 29286 | 2020-04-03 | Orleans | Louisiana | 22071 | 3476 | 148 |
29797 | 29797 | 2020-04-03 | Orleans | New York | 36073 | 6 | 0 |
30499 | 30499 | 2020-04-03 | Orleans | Vermont | 50019 | 8 | 0 |
31664 | 31664 | 2020-04-04 | Orleans | Louisiana | 22071 | 3966 | 153 |
32183 | 32183 | 2020-04-04 | Orleans | New York | 36073 | 10 | 0 |
32897 | 32897 | 2020-04-04 | Orleans | Vermont | 50019 | 8 | 0 |
34089 | 34089 | 2020-04-05 | Orleans | Louisiana | 22071 | 4066 | 161 |
34614 | 34614 | 2020-04-05 | Orleans | New York | 36073 | 11 | 0 |
35335 | 35335 | 2020-04-05 | Orleans | Vermont | 50019 | 8 | 0 |
36547 | 36547 | 2020-04-06 | Orleans | Louisiana | 22071 | 4565 | 171 |
37084 | 37084 | 2020-04-06 | Orleans | New York | 36073 | 13 | 0 |
37813 | 37813 | 2020-04-06 | Orleans | Vermont | 50019 | 8 | 0 |
39055 | 39055 | 2020-04-07 | Orleans | Louisiana | 22071 | 4942 | 185 |
39599 | 39599 | 2020-04-07 | Orleans | New York | 36073 | 15 | 0 |
40343 | 40343 | 2020-04-07 | Orleans | Vermont | 50019 | 8 | 0 |
41607 | 41607 | 2020-04-08 | Orleans | Louisiana | 22071 | 5070 | 208 |
42156 | 42156 | 2020-04-08 | Orleans | New York | 36073 | 16 | 0 |
42912 | 42912 | 2020-04-08 | Orleans | Vermont | 50019 | 8 | 0 |
44183 | 44183 | 2020-04-09 | Orleans | Louisiana | 22071 | 5242 | 224 |
44739 | 44739 | 2020-04-09 | Orleans | New York | 36073 | 22 | 0 |
45506 | 45506 | 2020-04-09 | Orleans | Vermont | 50019 | 8 | 0 |
46791 | 46791 | 2020-04-10 | Orleans | Louisiana | 22071 | 5416 | 225 |
47352 | 47352 | 2020-04-10 | Orleans | New York | 36073 | 24 | 0 |
48130 | 48130 | 2020-04-10 | Orleans | Vermont | 50019 | 8 | 0 |
49432 | 49432 | 2020-04-11 | Orleans | Louisiana | 22071 | 5535 | 232 |
50007 | 50007 | 2020-04-11 | Orleans | New York | 36073 | 24 | 0 |
50788 | 50788 | 2020-04-11 | Orleans | Vermont | 50019 | 8 | 0 |
52102 | 52102 | 2020-04-12 | Orleans | Louisiana | 22071 | 5600 | 235 |
52680 | 52680 | 2020-04-12 | Orleans | New York | 36073 | 25 | 0 |
53463 | 53463 | 2020-04-12 | Orleans | Vermont | 50019 | 8 | 0 |
54783 | 54783 | 2020-04-13 | Orleans | Louisiana | 22071 | 5651 | 244 |
55363 | 55363 | 2020-04-13 | Orleans | New York | 36073 | 26 | 0 |
56152 | 56152 | 2020-04-13 | Orleans | Vermont | 50019 | 8 | 0 |
57481 | 57481 | 2020-04-14 | Orleans | Louisiana | 22071 | 5718 | 276 |
58063 | 58063 | 2020-04-14 | Orleans | New York | 36073 | 31 | 0 |
58858 | 58858 | 2020-04-14 | Orleans | Vermont | 50019 | 8 | 0 |
60189 | 60189 | 2020-04-15 | Orleans | Louisiana | 22071 | 5769 | 287 |
60777 | 60777 | 2020-04-15 | Orleans | New York | 36073 | 33 | 0 |
61577 | 61577 | 2020-04-15 | Orleans | Vermont | 50019 | 8 | 0 |
62910 | 62910 | 2020-04-16 | Orleans | Louisiana | 22071 | 5847 | 302 |
63503 | 63503 | 2020-04-16 | Orleans | New York | 36073 | 34 | 0 |
64309 | 64309 | 2020-04-16 | Orleans | Vermont | 50019 | 8 | 0 |
65649 | 65649 | 2020-04-17 | Orleans | Louisiana | 22071 | 5906 | 317 |
66245 | 66245 | 2020-04-17 | Orleans | New York | 36073 | 34 | 0 |
67057 | 67057 | 2020-04-17 | Orleans | Vermont | 50019 | 8 | 0 |
68398 | 68398 | 2020-04-18 | Orleans | Louisiana | 22071 | 5953 | 324 |
69002 | 69002 | 2020-04-18 | Orleans | New York | 36073 | 41 | 0 |
69819 | 69819 | 2020-04-18 | Orleans | Vermont | 50019 | 9 | 0 |
71161 | 71161 | 2020-04-19 | Orleans | Louisiana | 22071 | 6000 | 329 |
71769 | 71769 | 2020-04-19 | Orleans | New York | 36073 | 46 | 1 |
72589 | 72589 | 2020-04-19 | Orleans | Vermont | 50019 | 9 | 0 |
73933 | 73933 | 2020-04-20 | Orleans | Louisiana | 22071 | 6148 | 339 |
74544 | 74544 | 2020-04-20 | Orleans | New York | 36073 | 46 | 1 |
75365 | 75365 | 2020-04-20 | Orleans | Vermont | 50019 | 9 | 0 |
76713 | 76713 | 2020-04-21 | Orleans | Louisiana | 22071 | 6169 | 344 |
77325 | 77325 | 2020-04-21 | Orleans | New York | 36073 | 53 | 1 |
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);