ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 2130 sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3227 | 3227 | 2020-03-17 | Ketchikan Gateway Borough | Alaska | 2130 | 1 | 0 |
3776 | 3776 | 2020-03-18 | Ketchikan Gateway Borough | Alaska | 2130 | 1 | 0 |
4419 | 4419 | 2020-03-19 | Ketchikan Gateway Borough | Alaska | 2130 | 2 | 0 |
5190 | 5190 | 2020-03-20 | Ketchikan Gateway Borough | Alaska | 2130 | 3 | 0 |
6107 | 6107 | 2020-03-21 | Ketchikan Gateway Borough | Alaska | 2130 | 6 | 0 |
7141 | 7141 | 2020-03-22 | Ketchikan Gateway Borough | Alaska | 2130 | 6 | 0 |
8283 | 8283 | 2020-03-23 | Ketchikan Gateway Borough | Alaska | 2130 | 6 | 0 |
9511 | 9511 | 2020-03-24 | Ketchikan Gateway Borough | Alaska | 2130 | 8 | 0 |
10881 | 10881 | 2020-03-25 | Ketchikan Gateway Borough | Alaska | 2130 | 11 | 0 |
12420 | 12420 | 2020-03-26 | Ketchikan Gateway Borough | Alaska | 2130 | 11 | 0 |
14083 | 14083 | 2020-03-27 | Ketchikan Gateway Borough | Alaska | 2130 | 12 | 0 |
15862 | 15862 | 2020-03-28 | Ketchikan Gateway Borough | Alaska | 2130 | 12 | 0 |
17746 | 17746 | 2020-03-29 | Ketchikan Gateway Borough | Alaska | 2130 | 13 | 0 |
19719 | 19719 | 2020-03-30 | Ketchikan Gateway Borough | Alaska | 2130 | 13 | 0 |
21791 | 21791 | 2020-03-31 | Ketchikan Gateway Borough | Alaska | 2130 | 13 | 0 |
23947 | 23947 | 2020-04-01 | Ketchikan Gateway Borough | Alaska | 2130 | 14 | 0 |
26169 | 26169 | 2020-04-02 | Ketchikan Gateway Borough | Alaska | 2130 | 14 | 0 |
28466 | 28466 | 2020-04-03 | Ketchikan Gateway Borough | Alaska | 2130 | 14 | 0 |
30823 | 30823 | 2020-04-04 | Ketchikan Gateway Borough | Alaska | 2130 | 14 | 0 |
33227 | 33227 | 2020-04-05 | Ketchikan Gateway Borough | Alaska | 2130 | 14 | 0 |
35666 | 35666 | 2020-04-06 | Ketchikan Gateway Borough | Alaska | 2130 | 14 | 0 |
38155 | 38155 | 2020-04-07 | Ketchikan Gateway Borough | Alaska | 2130 | 14 | 0 |
40697 | 40697 | 2020-04-08 | Ketchikan Gateway Borough | Alaska | 2130 | 14 | 0 |
43271 | 43271 | 2020-04-09 | Ketchikan Gateway Borough | Alaska | 2130 | 14 | 0 |
45869 | 45869 | 2020-04-10 | Ketchikan Gateway Borough | Alaska | 2130 | 14 | 0 |
48498 | 48498 | 2020-04-11 | Ketchikan Gateway Borough | Alaska | 2130 | 14 | 0 |
51160 | 51160 | 2020-04-12 | Ketchikan Gateway Borough | Alaska | 2130 | 15 | 0 |
53838 | 53838 | 2020-04-13 | Ketchikan Gateway Borough | Alaska | 2130 | 15 | 0 |
56530 | 56530 | 2020-04-14 | Ketchikan Gateway Borough | Alaska | 2130 | 15 | 0 |
59238 | 59238 | 2020-04-15 | Ketchikan Gateway Borough | Alaska | 2130 | 15 | 0 |
61956 | 61956 | 2020-04-16 | Ketchikan Gateway Borough | Alaska | 2130 | 15 | 0 |
64689 | 64689 | 2020-04-17 | Ketchikan Gateway Borough | Alaska | 2130 | 15 | 0 |
67437 | 67437 | 2020-04-18 | Ketchikan Gateway Borough | Alaska | 2130 | 15 | 0 |
70199 | 70199 | 2020-04-19 | Ketchikan Gateway Borough | Alaska | 2130 | 15 | 0 |
72968 | 72968 | 2020-04-20 | Ketchikan Gateway Borough | Alaska | 2130 | 15 | 0 |
75744 | 75744 | 2020-04-21 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
78527 | 78527 | 2020-04-22 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
81320 | 81320 | 2020-04-23 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
84121 | 84121 | 2020-04-24 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
86929 | 86929 | 2020-04-25 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
89745 | 89745 | 2020-04-26 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
92563 | 92563 | 2020-04-27 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
95393 | 95393 | 2020-04-28 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
98238 | 98238 | 2020-04-29 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
101088 | 101088 | 2020-04-30 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
103943 | 103943 | 2020-05-01 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
106808 | 106808 | 2020-05-02 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
109677 | 109677 | 2020-05-03 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
112552 | 112552 | 2020-05-04 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
115435 | 115435 | 2020-05-05 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
118394 | 118394 | 2020-05-06 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
121360 | 121360 | 2020-05-07 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
124340 | 124340 | 2020-05-08 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
127325 | 127325 | 2020-05-09 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
130315 | 130315 | 2020-05-10 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
133305 | 133305 | 2020-05-11 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
136295 | 136295 | 2020-05-12 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
139286 | 139286 | 2020-05-13 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
142282 | 142282 | 2020-05-14 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
145281 | 145281 | 2020-05-15 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
148284 | 148284 | 2020-05-16 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
151293 | 151293 | 2020-05-17 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
154305 | 154305 | 2020-05-18 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
157321 | 157321 | 2020-05-19 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
160346 | 160346 | 2020-05-20 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
163374 | 163374 | 2020-05-21 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
166406 | 166406 | 2020-05-22 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
169442 | 169442 | 2020-05-23 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
172483 | 172483 | 2020-05-24 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
175526 | 175526 | 2020-05-25 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
178571 | 178571 | 2020-05-26 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
181615 | 181615 | 2020-05-27 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
184667 | 184667 | 2020-05-28 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
187724 | 187724 | 2020-05-29 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
190788 | 190788 | 2020-05-30 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
193855 | 193855 | 2020-05-31 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
196925 | 196925 | 2020-06-01 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
199998 | 199998 | 2020-06-02 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
203074 | 203074 | 2020-06-03 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
206154 | 206154 | 2020-06-04 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
209236 | 209236 | 2020-06-05 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
212321 | 212321 | 2020-06-06 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
215408 | 215408 | 2020-06-07 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
218498 | 218498 | 2020-06-08 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
221592 | 221592 | 2020-06-09 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
224688 | 224688 | 2020-06-10 | Ketchikan Gateway Borough | Alaska | 2130 | 16 | 0 |
227789 | 227789 | 2020-06-11 | Ketchikan Gateway Borough | Alaska | 2130 | 17 | 0 |
230893 | 230893 | 2020-06-12 | Ketchikan Gateway Borough | Alaska | 2130 | 17 | 0 |
233998 | 233998 | 2020-06-13 | Ketchikan Gateway Borough | Alaska | 2130 | 20 | 0 |
237105 | 237105 | 2020-06-14 | Ketchikan Gateway Borough | Alaska | 2130 | 22 | 0 |
240213 | 240213 | 2020-06-15 | Ketchikan Gateway Borough | Alaska | 2130 | 22 | 0 |
243324 | 243324 | 2020-06-16 | Ketchikan Gateway Borough | Alaska | 2130 | 22 | 0 |
246437 | 246437 | 2020-06-17 | Ketchikan Gateway Borough | Alaska | 2130 | 24 | 0 |
249549 | 249549 | 2020-06-18 | Ketchikan Gateway Borough | Alaska | 2130 | 25 | 0 |
252664 | 252664 | 2020-06-19 | Ketchikan Gateway Borough | Alaska | 2130 | 25 | 0 |
255783 | 255783 | 2020-06-20 | Ketchikan Gateway Borough | Alaska | 2130 | 25 | 0 |
258910 | 258910 | 2020-06-21 | Ketchikan Gateway Borough | Alaska | 2130 | 25 | 0 |
262037 | 262037 | 2020-06-22 | Ketchikan Gateway Borough | Alaska | 2130 | 25 | 0 |
265166 | 265166 | 2020-06-23 | Ketchikan Gateway Borough | Alaska | 2130 | 27 | 0 |
268295 | 268295 | 2020-06-24 | Ketchikan Gateway Borough | Alaska | 2130 | 28 | 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);