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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387908 | 387908 | 2020-07-31 | Transylvania | North Carolina | 37175 | 121 | 1 |
384691 | 384691 | 2020-07-30 | Transylvania | North Carolina | 37175 | 116 | 1 |
381473 | 381473 | 2020-07-29 | Transylvania | North Carolina | 37175 | 111 | 1 |
378256 | 378256 | 2020-07-28 | Transylvania | North Carolina | 37175 | 110 | 1 |
375040 | 375040 | 2020-07-27 | Transylvania | North Carolina | 37175 | 108 | 1 |
371828 | 371828 | 2020-07-26 | Transylvania | North Carolina | 37175 | 107 | 1 |
368616 | 368616 | 2020-07-25 | Transylvania | North Carolina | 37175 | 106 | 1 |
365407 | 365407 | 2020-07-24 | Transylvania | North Carolina | 37175 | 103 | 1 |
362201 | 362201 | 2020-07-23 | Transylvania | North Carolina | 37175 | 101 | 1 |
358995 | 358995 | 2020-07-22 | Transylvania | North Carolina | 37175 | 98 | 1 |
355791 | 355791 | 2020-07-21 | Transylvania | North Carolina | 37175 | 96 | 1 |
352588 | 352588 | 2020-07-20 | Transylvania | North Carolina | 37175 | 90 | 1 |
349385 | 349385 | 2020-07-19 | Transylvania | North Carolina | 37175 | 84 | 1 |
346184 | 346184 | 2020-07-18 | Transylvania | North Carolina | 37175 | 75 | 1 |
342985 | 342985 | 2020-07-17 | Transylvania | North Carolina | 37175 | 68 | 1 |
339787 | 339787 | 2020-07-16 | Transylvania | North Carolina | 37175 | 62 | 1 |
336591 | 336591 | 2020-07-15 | Transylvania | North Carolina | 37175 | 61 | 1 |
333397 | 333397 | 2020-07-14 | Transylvania | North Carolina | 37175 | 58 | 1 |
330207 | 330207 | 2020-07-13 | Transylvania | North Carolina | 37175 | 52 | 1 |
327020 | 327020 | 2020-07-12 | Transylvania | North Carolina | 37175 | 48 | 1 |
323836 | 323836 | 2020-07-11 | Transylvania | North Carolina | 37175 | 43 | 1 |
320656 | 320656 | 2020-07-10 | Transylvania | North Carolina | 37175 | 41 | 1 |
317479 | 317479 | 2020-07-09 | Transylvania | North Carolina | 37175 | 38 | 1 |
314305 | 314305 | 2020-07-08 | Transylvania | North Carolina | 37175 | 38 | 1 |
311134 | 311134 | 2020-07-07 | Transylvania | North Carolina | 37175 | 37 | 1 |
307966 | 307966 | 2020-07-06 | Transylvania | North Carolina | 37175 | 36 | 1 |
304799 | 304799 | 2020-07-05 | Transylvania | North Carolina | 37175 | 30 | 1 |
301636 | 301636 | 2020-07-04 | Transylvania | North Carolina | 37175 | 26 | 1 |
298473 | 298473 | 2020-07-03 | Transylvania | North Carolina | 37175 | 25 | 1 |
295313 | 295313 | 2020-07-02 | Transylvania | North Carolina | 37175 | 22 | 1 |
292158 | 292158 | 2020-07-01 | Transylvania | North Carolina | 37175 | 22 | 1 |
289006 | 289006 | 2020-06-30 | Transylvania | North Carolina | 37175 | 22 | 1 |
285856 | 285856 | 2020-06-29 | Transylvania | North Carolina | 37175 | 22 | 1 |
282711 | 282711 | 2020-06-28 | Transylvania | North Carolina | 37175 | 21 | 1 |
279565 | 279565 | 2020-06-27 | Transylvania | North Carolina | 37175 | 20 | 1 |
276417 | 276417 | 2020-06-26 | Transylvania | North Carolina | 37175 | 19 | 1 |
273271 | 273271 | 2020-06-25 | Transylvania | North Carolina | 37175 | 19 | 1 |
270132 | 270132 | 2020-06-24 | Transylvania | North Carolina | 37175 | 19 | 1 |
266998 | 266998 | 2020-06-23 | Transylvania | North Carolina | 37175 | 19 | 1 |
263870 | 263870 | 2020-06-22 | Transylvania | North Carolina | 37175 | 19 | 1 |
260742 | 260742 | 2020-06-21 | Transylvania | North Carolina | 37175 | 19 | 1 |
257615 | 257615 | 2020-06-20 | Transylvania | North Carolina | 37175 | 19 | 1 |
254492 | 254492 | 2020-06-19 | Transylvania | North Carolina | 37175 | 18 | 1 |
251377 | 251377 | 2020-06-18 | Transylvania | North Carolina | 37175 | 17 | 1 |
248262 | 248262 | 2020-06-17 | Transylvania | North Carolina | 37175 | 17 | 1 |
245149 | 245149 | 2020-06-16 | Transylvania | North Carolina | 37175 | 17 | 1 |
242037 | 242037 | 2020-06-15 | Transylvania | North Carolina | 37175 | 17 | 1 |
238928 | 238928 | 2020-06-14 | Transylvania | North Carolina | 37175 | 17 | 1 |
235820 | 235820 | 2020-06-13 | Transylvania | North Carolina | 37175 | 16 | 1 |
232715 | 232715 | 2020-06-12 | Transylvania | North Carolina | 37175 | 16 | 1 |
229610 | 229610 | 2020-06-11 | Transylvania | North Carolina | 37175 | 16 | 1 |
226506 | 226506 | 2020-06-10 | Transylvania | North Carolina | 37175 | 16 | 1 |
223406 | 223406 | 2020-06-09 | Transylvania | North Carolina | 37175 | 16 | 1 |
220312 | 220312 | 2020-06-08 | Transylvania | North Carolina | 37175 | 16 | 1 |
217220 | 217220 | 2020-06-07 | Transylvania | North Carolina | 37175 | 16 | 1 |
214130 | 214130 | 2020-06-06 | Transylvania | North Carolina | 37175 | 16 | 1 |
211046 | 211046 | 2020-06-05 | Transylvania | North Carolina | 37175 | 16 | 1 |
207964 | 207964 | 2020-06-04 | Transylvania | North Carolina | 37175 | 15 | 1 |
204883 | 204883 | 2020-06-03 | Transylvania | North Carolina | 37175 | 15 | 0 |
201806 | 201806 | 2020-06-02 | Transylvania | North Carolina | 37175 | 14 | 0 |
198732 | 198732 | 2020-06-01 | Transylvania | North Carolina | 37175 | 14 | 0 |
195659 | 195659 | 2020-05-31 | Transylvania | North Carolina | 37175 | 13 | 0 |
192589 | 192589 | 2020-05-30 | Transylvania | North Carolina | 37175 | 13 | 0 |
189525 | 189525 | 2020-05-29 | Transylvania | North Carolina | 37175 | 12 | 0 |
186465 | 186465 | 2020-05-28 | Transylvania | North Carolina | 37175 | 12 | 0 |
183408 | 183408 | 2020-05-27 | Transylvania | North Carolina | 37175 | 11 | 0 |
180360 | 180360 | 2020-05-26 | Transylvania | North Carolina | 37175 | 11 | 0 |
177317 | 177317 | 2020-05-25 | Transylvania | North Carolina | 37175 | 11 | 0 |
174273 | 174273 | 2020-05-24 | Transylvania | North Carolina | 37175 | 11 | 0 |
171231 | 171231 | 2020-05-23 | Transylvania | North Carolina | 37175 | 11 | 0 |
168192 | 168192 | 2020-05-22 | Transylvania | North Carolina | 37175 | 9 | 0 |
165157 | 165157 | 2020-05-21 | Transylvania | North Carolina | 37175 | 9 | 0 |
162128 | 162128 | 2020-05-20 | Transylvania | North Carolina | 37175 | 8 | 0 |
159101 | 159101 | 2020-05-19 | Transylvania | North Carolina | 37175 | 8 | 0 |
156082 | 156082 | 2020-05-18 | Transylvania | North Carolina | 37175 | 7 | 0 |
153065 | 153065 | 2020-05-17 | Transylvania | North Carolina | 37175 | 7 | 0 |
150055 | 150055 | 2020-05-16 | Transylvania | North Carolina | 37175 | 7 | 0 |
147048 | 147048 | 2020-05-15 | Transylvania | North Carolina | 37175 | 7 | 0 |
144047 | 144047 | 2020-05-14 | Transylvania | North Carolina | 37175 | 7 | 0 |
141052 | 141052 | 2020-05-13 | Transylvania | North Carolina | 37175 | 7 | 0 |
138056 | 138056 | 2020-05-12 | Transylvania | North Carolina | 37175 | 7 | 0 |
135066 | 135066 | 2020-05-11 | Transylvania | North Carolina | 37175 | 7 | 0 |
132075 | 132075 | 2020-05-10 | Transylvania | North Carolina | 37175 | 7 | 0 |
129086 | 129086 | 2020-05-09 | Transylvania | North Carolina | 37175 | 7 | 0 |
126097 | 126097 | 2020-05-08 | Transylvania | North Carolina | 37175 | 7 | 0 |
123114 | 123114 | 2020-05-07 | Transylvania | North Carolina | 37175 | 7 | 0 |
120139 | 120139 | 2020-05-06 | Transylvania | North Carolina | 37175 | 7 | 0 |
117178 | 117178 | 2020-05-05 | Transylvania | North Carolina | 37175 | 7 | 0 |
114298 | 114298 | 2020-05-04 | Transylvania | North Carolina | 37175 | 7 | 0 |
111417 | 111417 | 2020-05-03 | Transylvania | North Carolina | 37175 | 7 | 0 |
108544 | 108544 | 2020-05-02 | Transylvania | North Carolina | 37175 | 8 | 0 |
105677 | 105677 | 2020-05-01 | Transylvania | North Carolina | 37175 | 7 | 0 |
102815 | 102815 | 2020-04-30 | Transylvania | North Carolina | 37175 | 7 | 0 |
99962 | 99962 | 2020-04-29 | Transylvania | North Carolina | 37175 | 7 | 0 |
97113 | 97113 | 2020-04-28 | Transylvania | North Carolina | 37175 | 7 | 0 |
94276 | 94276 | 2020-04-27 | Transylvania | North Carolina | 37175 | 7 | 0 |
91450 | 91450 | 2020-04-26 | Transylvania | North Carolina | 37175 | 7 | 0 |
88635 | 88635 | 2020-04-25 | Transylvania | North Carolina | 37175 | 7 | 0 |
85822 | 85822 | 2020-04-24 | Transylvania | North Carolina | 37175 | 7 | 0 |
83018 | 83018 | 2020-04-23 | Transylvania | North Carolina | 37175 | 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);