ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 37175 and state = "North Carolina" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
10390 | 10390 | 2020-03-24 | Transylvania | North Carolina | 37175 | 1 | 0 |
11835 | 11835 | 2020-03-25 | Transylvania | North Carolina | 37175 | 2 | 0 |
13439 | 13439 | 2020-03-26 | Transylvania | North Carolina | 37175 | 2 | 0 |
15176 | 15176 | 2020-03-27 | Transylvania | North Carolina | 37175 | 2 | 0 |
17010 | 17010 | 2020-03-28 | Transylvania | North Carolina | 37175 | 3 | 0 |
18942 | 18942 | 2020-03-29 | Transylvania | North Carolina | 37175 | 3 | 0 |
20983 | 20983 | 2020-03-30 | Transylvania | North Carolina | 37175 | 3 | 0 |
23111 | 23111 | 2020-03-31 | Transylvania | North Carolina | 37175 | 5 | 0 |
25305 | 25305 | 2020-04-01 | Transylvania | North Carolina | 37175 | 5 | 0 |
27571 | 27571 | 2020-04-02 | Transylvania | North Carolina | 37175 | 5 | 0 |
29898 | 29898 | 2020-04-03 | Transylvania | North Carolina | 37175 | 5 | 0 |
32285 | 32285 | 2020-04-04 | Transylvania | North Carolina | 37175 | 5 | 0 |
34717 | 34717 | 2020-04-05 | Transylvania | North Carolina | 37175 | 5 | 0 |
37186 | 37186 | 2020-04-06 | Transylvania | North Carolina | 37175 | 5 | 0 |
39702 | 39702 | 2020-04-07 | Transylvania | North Carolina | 37175 | 6 | 0 |
42259 | 42259 | 2020-04-08 | Transylvania | North Carolina | 37175 | 6 | 0 |
44843 | 44843 | 2020-04-09 | Transylvania | North Carolina | 37175 | 6 | 0 |
47456 | 47456 | 2020-04-10 | Transylvania | North Carolina | 37175 | 6 | 0 |
50111 | 50111 | 2020-04-11 | Transylvania | North Carolina | 37175 | 6 | 0 |
52784 | 52784 | 2020-04-12 | Transylvania | North Carolina | 37175 | 6 | 0 |
55468 | 55468 | 2020-04-13 | Transylvania | North Carolina | 37175 | 6 | 0 |
58168 | 58168 | 2020-04-14 | Transylvania | North Carolina | 37175 | 6 | 0 |
60882 | 60882 | 2020-04-15 | Transylvania | North Carolina | 37175 | 6 | 0 |
63608 | 63608 | 2020-04-16 | Transylvania | North Carolina | 37175 | 6 | 0 |
66351 | 66351 | 2020-04-17 | Transylvania | North Carolina | 37175 | 6 | 0 |
69108 | 69108 | 2020-04-18 | Transylvania | North Carolina | 37175 | 7 | 0 |
71874 | 71874 | 2020-04-19 | Transylvania | North Carolina | 37175 | 7 | 0 |
74649 | 74649 | 2020-04-20 | Transylvania | North Carolina | 37175 | 8 | 0 |
77430 | 77430 | 2020-04-21 | Transylvania | North Carolina | 37175 | 7 | 0 |
80219 | 80219 | 2020-04-22 | Transylvania | North Carolina | 37175 | 7 | 0 |
83018 | 83018 | 2020-04-23 | Transylvania | North Carolina | 37175 | 7 | 0 |
85822 | 85822 | 2020-04-24 | Transylvania | North Carolina | 37175 | 7 | 0 |
88635 | 88635 | 2020-04-25 | Transylvania | North Carolina | 37175 | 7 | 0 |
91450 | 91450 | 2020-04-26 | Transylvania | North Carolina | 37175 | 7 | 0 |
94276 | 94276 | 2020-04-27 | Transylvania | North Carolina | 37175 | 7 | 0 |
97113 | 97113 | 2020-04-28 | Transylvania | North Carolina | 37175 | 7 | 0 |
99962 | 99962 | 2020-04-29 | Transylvania | North Carolina | 37175 | 7 | 0 |
102815 | 102815 | 2020-04-30 | Transylvania | North Carolina | 37175 | 7 | 0 |
105677 | 105677 | 2020-05-01 | Transylvania | North Carolina | 37175 | 7 | 0 |
108544 | 108544 | 2020-05-02 | Transylvania | North Carolina | 37175 | 8 | 0 |
111417 | 111417 | 2020-05-03 | Transylvania | North Carolina | 37175 | 7 | 0 |
114298 | 114298 | 2020-05-04 | Transylvania | North Carolina | 37175 | 7 | 0 |
117178 | 117178 | 2020-05-05 | Transylvania | North Carolina | 37175 | 7 | 0 |
120139 | 120139 | 2020-05-06 | Transylvania | North Carolina | 37175 | 7 | 0 |
123114 | 123114 | 2020-05-07 | Transylvania | North Carolina | 37175 | 7 | 0 |
126097 | 126097 | 2020-05-08 | Transylvania | North Carolina | 37175 | 7 | 0 |
129086 | 129086 | 2020-05-09 | Transylvania | North Carolina | 37175 | 7 | 0 |
132075 | 132075 | 2020-05-10 | Transylvania | North Carolina | 37175 | 7 | 0 |
135066 | 135066 | 2020-05-11 | Transylvania | North Carolina | 37175 | 7 | 0 |
138056 | 138056 | 2020-05-12 | Transylvania | North Carolina | 37175 | 7 | 0 |
141052 | 141052 | 2020-05-13 | Transylvania | North Carolina | 37175 | 7 | 0 |
144047 | 144047 | 2020-05-14 | Transylvania | North Carolina | 37175 | 7 | 0 |
147048 | 147048 | 2020-05-15 | Transylvania | North Carolina | 37175 | 7 | 0 |
150055 | 150055 | 2020-05-16 | Transylvania | North Carolina | 37175 | 7 | 0 |
153065 | 153065 | 2020-05-17 | Transylvania | North Carolina | 37175 | 7 | 0 |
156082 | 156082 | 2020-05-18 | Transylvania | North Carolina | 37175 | 7 | 0 |
159101 | 159101 | 2020-05-19 | Transylvania | North Carolina | 37175 | 8 | 0 |
162128 | 162128 | 2020-05-20 | Transylvania | North Carolina | 37175 | 8 | 0 |
165157 | 165157 | 2020-05-21 | Transylvania | North Carolina | 37175 | 9 | 0 |
168192 | 168192 | 2020-05-22 | Transylvania | North Carolina | 37175 | 9 | 0 |
171231 | 171231 | 2020-05-23 | Transylvania | North Carolina | 37175 | 11 | 0 |
174273 | 174273 | 2020-05-24 | Transylvania | North Carolina | 37175 | 11 | 0 |
177317 | 177317 | 2020-05-25 | Transylvania | North Carolina | 37175 | 11 | 0 |
180360 | 180360 | 2020-05-26 | Transylvania | North Carolina | 37175 | 11 | 0 |
183408 | 183408 | 2020-05-27 | Transylvania | North Carolina | 37175 | 11 | 0 |
186465 | 186465 | 2020-05-28 | Transylvania | North Carolina | 37175 | 12 | 0 |
189525 | 189525 | 2020-05-29 | Transylvania | North Carolina | 37175 | 12 | 0 |
192589 | 192589 | 2020-05-30 | Transylvania | North Carolina | 37175 | 13 | 0 |
195659 | 195659 | 2020-05-31 | Transylvania | North Carolina | 37175 | 13 | 0 |
198732 | 198732 | 2020-06-01 | Transylvania | North Carolina | 37175 | 14 | 0 |
201806 | 201806 | 2020-06-02 | Transylvania | North Carolina | 37175 | 14 | 0 |
204883 | 204883 | 2020-06-03 | Transylvania | North Carolina | 37175 | 15 | 0 |
207964 | 207964 | 2020-06-04 | Transylvania | North Carolina | 37175 | 15 | 1 |
211046 | 211046 | 2020-06-05 | Transylvania | North Carolina | 37175 | 16 | 1 |
214130 | 214130 | 2020-06-06 | Transylvania | North Carolina | 37175 | 16 | 1 |
217220 | 217220 | 2020-06-07 | Transylvania | North Carolina | 37175 | 16 | 1 |
220312 | 220312 | 2020-06-08 | Transylvania | North Carolina | 37175 | 16 | 1 |
223406 | 223406 | 2020-06-09 | Transylvania | North Carolina | 37175 | 16 | 1 |
226506 | 226506 | 2020-06-10 | Transylvania | North Carolina | 37175 | 16 | 1 |
229610 | 229610 | 2020-06-11 | Transylvania | North Carolina | 37175 | 16 | 1 |
232715 | 232715 | 2020-06-12 | Transylvania | North Carolina | 37175 | 16 | 1 |
235820 | 235820 | 2020-06-13 | Transylvania | North Carolina | 37175 | 16 | 1 |
238928 | 238928 | 2020-06-14 | Transylvania | North Carolina | 37175 | 17 | 1 |
242037 | 242037 | 2020-06-15 | Transylvania | North Carolina | 37175 | 17 | 1 |
245149 | 245149 | 2020-06-16 | Transylvania | North Carolina | 37175 | 17 | 1 |
248262 | 248262 | 2020-06-17 | Transylvania | North Carolina | 37175 | 17 | 1 |
251377 | 251377 | 2020-06-18 | Transylvania | North Carolina | 37175 | 17 | 1 |
254492 | 254492 | 2020-06-19 | Transylvania | North Carolina | 37175 | 18 | 1 |
257615 | 257615 | 2020-06-20 | Transylvania | North Carolina | 37175 | 19 | 1 |
260742 | 260742 | 2020-06-21 | Transylvania | North Carolina | 37175 | 19 | 1 |
263870 | 263870 | 2020-06-22 | Transylvania | North Carolina | 37175 | 19 | 1 |
266998 | 266998 | 2020-06-23 | Transylvania | North Carolina | 37175 | 19 | 1 |
270132 | 270132 | 2020-06-24 | Transylvania | North Carolina | 37175 | 19 | 1 |
273271 | 273271 | 2020-06-25 | Transylvania | North Carolina | 37175 | 19 | 1 |
276417 | 276417 | 2020-06-26 | Transylvania | North Carolina | 37175 | 19 | 1 |
279565 | 279565 | 2020-06-27 | Transylvania | North Carolina | 37175 | 20 | 1 |
282711 | 282711 | 2020-06-28 | Transylvania | North Carolina | 37175 | 21 | 1 |
285856 | 285856 | 2020-06-29 | Transylvania | North Carolina | 37175 | 22 | 1 |
289006 | 289006 | 2020-06-30 | Transylvania | North Carolina | 37175 | 22 | 1 |
292158 | 292158 | 2020-07-01 | Transylvania | North Carolina | 37175 | 22 | 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);