ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,245 rows where county = "Oneida" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
county 1
- Oneida · 2,245 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5731 | 5731 | 2020-03-20 | Oneida | New York | 36065 | 2 | 0 |
6725 | 6725 | 2020-03-21 | Oneida | New York | 36065 | 4 | 0 |
7820 | 7820 | 2020-03-22 | Oneida | New York | 36065 | 5 | 0 |
9018 | 9018 | 2020-03-23 | Oneida | New York | 36065 | 7 | 0 |
10325 | 10325 | 2020-03-24 | Oneida | New York | 36065 | 8 | 0 |
11761 | 11761 | 2020-03-25 | Oneida | New York | 36065 | 9 | 0 |
13364 | 13364 | 2020-03-26 | Oneida | New York | 36065 | 13 | 0 |
15098 | 15098 | 2020-03-27 | Oneida | New York | 36065 | 13 | 0 |
16928 | 16928 | 2020-03-28 | Oneida | New York | 36065 | 23 | 0 |
17653 | 17653 | 2020-03-28 | Oneida | Wisconsin | 55085 | 1 | 0 |
18853 | 18853 | 2020-03-29 | Oneida | New York | 36065 | 26 | 0 |
19622 | 19622 | 2020-03-29 | Oneida | Wisconsin | 55085 | 1 | 0 |
20892 | 20892 | 2020-03-30 | Oneida | New York | 36065 | 34 | 0 |
21694 | 21694 | 2020-03-30 | Oneida | Wisconsin | 55085 | 3 | 0 |
23015 | 23015 | 2020-03-31 | Oneida | New York | 36065 | 40 | 0 |
23847 | 23847 | 2020-03-31 | Oneida | Wisconsin | 55085 | 3 | 0 |
25209 | 25209 | 2020-04-01 | Oneida | New York | 36065 | 50 | 1 |
26068 | 26068 | 2020-04-01 | Oneida | Wisconsin | 55085 | 3 | 0 |
27469 | 27469 | 2020-04-02 | Oneida | New York | 36065 | 68 | 1 |
28361 | 28361 | 2020-04-02 | Oneida | Wisconsin | 55085 | 3 | 0 |
29793 | 29793 | 2020-04-03 | Oneida | New York | 36065 | 68 | 1 |
30716 | 30716 | 2020-04-03 | Oneida | Wisconsin | 55085 | 3 | 0 |
32179 | 32179 | 2020-04-04 | Oneida | New York | 36065 | 80 | 2 |
33118 | 33118 | 2020-04-04 | Oneida | Wisconsin | 55085 | 3 | 0 |
34610 | 34610 | 2020-04-05 | Oneida | New York | 36065 | 87 | 2 |
35557 | 35557 | 2020-04-05 | Oneida | Wisconsin | 55085 | 3 | 0 |
37080 | 37080 | 2020-04-06 | Oneida | New York | 36065 | 100 | 2 |
38044 | 38044 | 2020-04-06 | Oneida | Wisconsin | 55085 | 3 | 0 |
39595 | 39595 | 2020-04-07 | Oneida | New York | 36065 | 118 | 2 |
40586 | 40586 | 2020-04-07 | Oneida | Wisconsin | 55085 | 5 | 0 |
42152 | 42152 | 2020-04-08 | Oneida | New York | 36065 | 125 | 2 |
43158 | 43158 | 2020-04-08 | Oneida | Wisconsin | 55085 | 5 | 0 |
44735 | 44735 | 2020-04-09 | Oneida | New York | 36065 | 158 | 2 |
45755 | 45755 | 2020-04-09 | Oneida | Wisconsin | 55085 | 5 | 0 |
47348 | 47348 | 2020-04-10 | Oneida | New York | 36065 | 172 | 2 |
48383 | 48383 | 2020-04-10 | Oneida | Wisconsin | 55085 | 5 | 0 |
50003 | 50003 | 2020-04-11 | Oneida | New York | 36065 | 181 | 2 |
51043 | 51043 | 2020-04-11 | Oneida | Wisconsin | 55085 | 5 | 0 |
52676 | 52676 | 2020-04-12 | Oneida | New York | 36065 | 195 | 2 |
53720 | 53720 | 2020-04-12 | Oneida | Wisconsin | 55085 | 6 | 0 |
55359 | 55359 | 2020-04-13 | Oneida | New York | 36065 | 206 | 3 |
56411 | 56411 | 2020-04-13 | Oneida | Wisconsin | 55085 | 6 | 0 |
58059 | 58059 | 2020-04-14 | Oneida | New York | 36065 | 229 | 3 |
59118 | 59118 | 2020-04-14 | Oneida | Wisconsin | 55085 | 6 | 0 |
60773 | 60773 | 2020-04-15 | Oneida | New York | 36065 | 246 | 4 |
61837 | 61837 | 2020-04-15 | Oneida | Wisconsin | 55085 | 6 | 0 |
63499 | 63499 | 2020-04-16 | Oneida | New York | 36065 | 249 | 4 |
64570 | 64570 | 2020-04-16 | Oneida | Wisconsin | 55085 | 6 | 0 |
66241 | 66241 | 2020-04-17 | Oneida | New York | 36065 | 261 | 4 |
67318 | 67318 | 2020-04-17 | Oneida | Wisconsin | 55085 | 6 | 0 |
68998 | 68998 | 2020-04-18 | Oneida | New York | 36065 | 268 | 4 |
70080 | 70080 | 2020-04-18 | Oneida | Wisconsin | 55085 | 6 | 0 |
71765 | 71765 | 2020-04-19 | Oneida | New York | 36065 | 275 | 4 |
72849 | 72849 | 2020-04-19 | Oneida | Wisconsin | 55085 | 6 | 0 |
74540 | 74540 | 2020-04-20 | Oneida | New York | 36065 | 279 | 6 |
75625 | 75625 | 2020-04-20 | Oneida | Wisconsin | 55085 | 6 | 0 |
77321 | 77321 | 2020-04-21 | Oneida | New York | 36065 | 284 | 6 |
78408 | 78408 | 2020-04-21 | Oneida | Wisconsin | 55085 | 6 | 0 |
80110 | 80110 | 2020-04-22 | Oneida | New York | 36065 | 301 | 8 |
81201 | 81201 | 2020-04-22 | Oneida | Wisconsin | 55085 | 6 | 0 |
82909 | 82909 | 2020-04-23 | Oneida | New York | 36065 | 317 | 8 |
84002 | 84002 | 2020-04-23 | Oneida | Wisconsin | 55085 | 6 | 0 |
85713 | 85713 | 2020-04-24 | Oneida | New York | 36065 | 323 | 8 |
86809 | 86809 | 2020-04-24 | Oneida | Wisconsin | 55085 | 6 | 0 |
88525 | 88525 | 2020-04-25 | Oneida | New York | 36065 | 364 | 8 |
89625 | 89625 | 2020-04-25 | Oneida | Wisconsin | 55085 | 6 | 0 |
91340 | 91340 | 2020-04-26 | Oneida | New York | 36065 | 384 | 11 |
92443 | 92443 | 2020-04-26 | Oneida | Wisconsin | 55085 | 6 | 0 |
94165 | 94165 | 2020-04-27 | Oneida | New York | 36065 | 397 | 11 |
95273 | 95273 | 2020-04-27 | Oneida | Wisconsin | 55085 | 6 | 0 |
97001 | 97001 | 2020-04-28 | Oneida | New York | 36065 | 411 | 12 |
98118 | 98118 | 2020-04-28 | Oneida | Wisconsin | 55085 | 6 | 0 |
99848 | 99848 | 2020-04-29 | Oneida | New York | 36065 | 422 | 14 |
100968 | 100968 | 2020-04-29 | Oneida | Wisconsin | 55085 | 6 | 0 |
102701 | 102701 | 2020-04-30 | Oneida | New York | 36065 | 439 | 14 |
103823 | 103823 | 2020-04-30 | Oneida | Wisconsin | 55085 | 6 | 0 |
105563 | 105563 | 2020-05-01 | Oneida | New York | 36065 | 451 | 14 |
106688 | 106688 | 2020-05-01 | Oneida | Wisconsin | 55085 | 6 | 0 |
108430 | 108430 | 2020-05-02 | Oneida | New York | 36065 | 474 | 14 |
109557 | 109557 | 2020-05-02 | Oneida | Wisconsin | 55085 | 6 | 0 |
111303 | 111303 | 2020-05-03 | Oneida | New York | 36065 | 489 | 16 |
112432 | 112432 | 2020-05-03 | Oneida | Wisconsin | 55085 | 6 | 0 |
114184 | 114184 | 2020-05-04 | Oneida | New York | 36065 | 550 | 17 |
115315 | 115315 | 2020-05-04 | Oneida | Wisconsin | 55085 | 6 | 0 |
117064 | 117064 | 2020-05-05 | Oneida | New York | 36065 | 574 | 17 |
118274 | 118274 | 2020-05-05 | Oneida | Wisconsin | 55085 | 6 | 0 |
120025 | 120025 | 2020-05-06 | Oneida | New York | 36065 | 579 | 22 |
121240 | 121240 | 2020-05-06 | Oneida | Wisconsin | 55085 | 6 | 0 |
123000 | 123000 | 2020-05-07 | Oneida | New York | 36065 | 609 | 22 |
124220 | 124220 | 2020-05-07 | Oneida | Wisconsin | 55085 | 6 | 0 |
125983 | 125983 | 2020-05-08 | Oneida | New York | 36065 | 620 | 23 |
127205 | 127205 | 2020-05-08 | Oneida | Wisconsin | 55085 | 7 | 0 |
128972 | 128972 | 2020-05-09 | Oneida | New York | 36065 | 638 | 24 |
130195 | 130195 | 2020-05-09 | Oneida | Wisconsin | 55085 | 7 | 0 |
131961 | 131961 | 2020-05-10 | Oneida | New York | 36065 | 660 | 25 |
133185 | 133185 | 2020-05-10 | Oneida | Wisconsin | 55085 | 7 | 0 |
134952 | 134952 | 2020-05-11 | Oneida | New York | 36065 | 669 | 25 |
136175 | 136175 | 2020-05-11 | Oneida | Wisconsin | 55085 | 7 | 0 |
137942 | 137942 | 2020-05-12 | Oneida | New York | 36065 | 676 | 26 |
139166 | 139166 | 2020-05-12 | Oneida | Wisconsin | 55085 | 7 | 0 |
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);