ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 37081 and state = "North Carolina" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- …
state 1
- North Carolina · 787 ✖
fips 1
- 37081 · 787 ✖
county 1
- Guilford 787
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4176 | 4176 | 2020-03-18 | Guilford | North Carolina | 37081 | 1 | 0 |
4907 | 4907 | 2020-03-19 | Guilford | North Carolina | 37081 | 2 | 0 |
5761 | 5761 | 2020-03-20 | Guilford | North Carolina | 37081 | 4 | 0 |
6758 | 6758 | 2020-03-21 | Guilford | North Carolina | 37081 | 4 | 0 |
7858 | 7858 | 2020-03-22 | Guilford | North Carolina | 37081 | 11 | 0 |
9059 | 9059 | 2020-03-23 | Guilford | North Carolina | 37081 | 11 | 0 |
10367 | 10367 | 2020-03-24 | Guilford | North Carolina | 37081 | 16 | 0 |
11808 | 11808 | 2020-03-25 | Guilford | North Carolina | 37081 | 22 | 0 |
13412 | 13412 | 2020-03-26 | Guilford | North Carolina | 37081 | 24 | 0 |
15147 | 15147 | 2020-03-27 | Guilford | North Carolina | 37081 | 31 | 0 |
16979 | 16979 | 2020-03-28 | Guilford | North Carolina | 37081 | 34 | 0 |
18909 | 18909 | 2020-03-29 | Guilford | North Carolina | 37081 | 39 | 0 |
20949 | 20949 | 2020-03-30 | Guilford | North Carolina | 37081 | 44 | 0 |
23075 | 23075 | 2020-03-31 | Guilford | North Carolina | 37081 | 52 | 1 |
25269 | 25269 | 2020-04-01 | Guilford | North Carolina | 37081 | 55 | 1 |
27532 | 27532 | 2020-04-02 | Guilford | North Carolina | 37081 | 71 | 1 |
29858 | 29858 | 2020-04-03 | Guilford | North Carolina | 37081 | 79 | 3 |
32245 | 32245 | 2020-04-04 | Guilford | North Carolina | 37081 | 94 | 4 |
34676 | 34676 | 2020-04-05 | Guilford | North Carolina | 37081 | 96 | 4 |
37145 | 37145 | 2020-04-06 | Guilford | North Carolina | 37081 | 104 | 4 |
39660 | 39660 | 2020-04-07 | Guilford | North Carolina | 37081 | 119 | 5 |
42217 | 42217 | 2020-04-08 | Guilford | North Carolina | 37081 | 122 | 8 |
44800 | 44800 | 2020-04-09 | Guilford | North Carolina | 37081 | 125 | 8 |
47413 | 47413 | 2020-04-10 | Guilford | North Carolina | 37081 | 127 | 9 |
50068 | 50068 | 2020-04-11 | Guilford | North Carolina | 37081 | 134 | 9 |
52741 | 52741 | 2020-04-12 | Guilford | North Carolina | 37081 | 135 | 9 |
55424 | 55424 | 2020-04-13 | Guilford | North Carolina | 37081 | 138 | 10 |
58124 | 58124 | 2020-04-14 | Guilford | North Carolina | 37081 | 137 | 10 |
60838 | 60838 | 2020-04-15 | Guilford | North Carolina | 37081 | 149 | 10 |
63564 | 63564 | 2020-04-16 | Guilford | North Carolina | 37081 | 154 | 10 |
66307 | 66307 | 2020-04-17 | Guilford | North Carolina | 37081 | 162 | 12 |
69064 | 69064 | 2020-04-18 | Guilford | North Carolina | 37081 | 168 | 13 |
71830 | 71830 | 2020-04-19 | Guilford | North Carolina | 37081 | 172 | 13 |
74605 | 74605 | 2020-04-20 | Guilford | North Carolina | 37081 | 175 | 13 |
77386 | 77386 | 2020-04-21 | Guilford | North Carolina | 37081 | 190 | 14 |
80175 | 80175 | 2020-04-22 | Guilford | North Carolina | 37081 | 226 | 14 |
82974 | 82974 | 2020-04-23 | Guilford | North Carolina | 37081 | 240 | 15 |
85778 | 85778 | 2020-04-24 | Guilford | North Carolina | 37081 | 272 | 16 |
88590 | 88590 | 2020-04-25 | Guilford | North Carolina | 37081 | 293 | 19 |
91405 | 91405 | 2020-04-26 | Guilford | North Carolina | 37081 | 299 | 19 |
94231 | 94231 | 2020-04-27 | Guilford | North Carolina | 37081 | 301 | 23 |
97068 | 97068 | 2020-04-28 | Guilford | North Carolina | 37081 | 318 | 23 |
99915 | 99915 | 2020-04-29 | Guilford | North Carolina | 37081 | 357 | 23 |
102768 | 102768 | 2020-04-30 | Guilford | North Carolina | 37081 | 381 | 26 |
105630 | 105630 | 2020-05-01 | Guilford | North Carolina | 37081 | 415 | 30 |
108497 | 108497 | 2020-05-02 | Guilford | North Carolina | 37081 | 437 | 31 |
111370 | 111370 | 2020-05-03 | Guilford | North Carolina | 37081 | 439 | 31 |
114251 | 114251 | 2020-05-04 | Guilford | North Carolina | 37081 | 443 | 31 |
117131 | 117131 | 2020-05-05 | Guilford | North Carolina | 37081 | 464 | 33 |
120092 | 120092 | 2020-05-06 | Guilford | North Carolina | 37081 | 507 | 35 |
123067 | 123067 | 2020-05-07 | Guilford | North Carolina | 37081 | 536 | 35 |
126050 | 126050 | 2020-05-08 | Guilford | North Carolina | 37081 | 553 | 38 |
129039 | 129039 | 2020-05-09 | Guilford | North Carolina | 37081 | 574 | 38 |
132028 | 132028 | 2020-05-10 | Guilford | North Carolina | 37081 | 592 | 38 |
135019 | 135019 | 2020-05-11 | Guilford | North Carolina | 37081 | 609 | 38 |
138009 | 138009 | 2020-05-12 | Guilford | North Carolina | 37081 | 626 | 42 |
141005 | 141005 | 2020-05-13 | Guilford | North Carolina | 37081 | 670 | 44 |
144000 | 144000 | 2020-05-14 | Guilford | North Carolina | 37081 | 705 | 45 |
147001 | 147001 | 2020-05-15 | Guilford | North Carolina | 37081 | 725 | 46 |
150008 | 150008 | 2020-05-16 | Guilford | North Carolina | 37081 | 776 | 47 |
153018 | 153018 | 2020-05-17 | Guilford | North Carolina | 37081 | 846 | 47 |
156035 | 156035 | 2020-05-18 | Guilford | North Carolina | 37081 | 872 | 47 |
159054 | 159054 | 2020-05-19 | Guilford | North Carolina | 37081 | 904 | 49 |
162081 | 162081 | 2020-05-20 | Guilford | North Carolina | 37081 | 931 | 49 |
165110 | 165110 | 2020-05-21 | Guilford | North Carolina | 37081 | 962 | 50 |
168145 | 168145 | 2020-05-22 | Guilford | North Carolina | 37081 | 977 | 50 |
171184 | 171184 | 2020-05-23 | Guilford | North Carolina | 37081 | 1033 | 52 |
174226 | 174226 | 2020-05-24 | Guilford | North Carolina | 37081 | 1049 | 52 |
177270 | 177270 | 2020-05-25 | Guilford | North Carolina | 37081 | 1073 | 52 |
180313 | 180313 | 2020-05-26 | Guilford | North Carolina | 37081 | 1092 | 53 |
183361 | 183361 | 2020-05-27 | Guilford | North Carolina | 37081 | 1143 | 54 |
186418 | 186418 | 2020-05-28 | Guilford | North Carolina | 37081 | 1173 | 56 |
189478 | 189478 | 2020-05-29 | Guilford | North Carolina | 37081 | 1195 | 65 |
192542 | 192542 | 2020-05-30 | Guilford | North Carolina | 37081 | 1227 | 65 |
195612 | 195612 | 2020-05-31 | Guilford | North Carolina | 37081 | 1264 | 65 |
198685 | 198685 | 2020-06-01 | Guilford | North Carolina | 37081 | 1288 | 65 |
201759 | 201759 | 2020-06-02 | Guilford | North Carolina | 37081 | 1352 | 70 |
204836 | 204836 | 2020-06-03 | Guilford | North Carolina | 37081 | 1415 | 71 |
207917 | 207917 | 2020-06-04 | Guilford | North Carolina | 37081 | 1498 | 75 |
210999 | 210999 | 2020-06-05 | Guilford | North Carolina | 37081 | 1574 | 75 |
214083 | 214083 | 2020-06-06 | Guilford | North Carolina | 37081 | 1574 | 78 |
217173 | 217173 | 2020-06-07 | Guilford | North Carolina | 37081 | 1614 | 78 |
220265 | 220265 | 2020-06-08 | Guilford | North Carolina | 37081 | 1671 | 81 |
223359 | 223359 | 2020-06-09 | Guilford | North Carolina | 37081 | 1779 | 87 |
226459 | 226459 | 2020-06-10 | Guilford | North Carolina | 37081 | 1853 | 91 |
229563 | 229563 | 2020-06-11 | Guilford | North Carolina | 37081 | 1891 | 93 |
232668 | 232668 | 2020-06-12 | Guilford | North Carolina | 37081 | 1941 | 94 |
235773 | 235773 | 2020-06-13 | Guilford | North Carolina | 37081 | 1983 | 94 |
238881 | 238881 | 2020-06-14 | Guilford | North Carolina | 37081 | 2032 | 94 |
241990 | 241990 | 2020-06-15 | Guilford | North Carolina | 37081 | 2061 | 95 |
245102 | 245102 | 2020-06-16 | Guilford | North Carolina | 37081 | 2148 | 99 |
248215 | 248215 | 2020-06-17 | Guilford | North Carolina | 37081 | 2194 | 101 |
251330 | 251330 | 2020-06-18 | Guilford | North Carolina | 37081 | 2244 | 101 |
254445 | 254445 | 2020-06-19 | Guilford | North Carolina | 37081 | 2320 | 105 |
257568 | 257568 | 2020-06-20 | Guilford | North Carolina | 37081 | 2352 | 106 |
260695 | 260695 | 2020-06-21 | Guilford | North Carolina | 37081 | 2402 | 106 |
263823 | 263823 | 2020-06-22 | Guilford | North Carolina | 37081 | 2434 | 106 |
266951 | 266951 | 2020-06-23 | Guilford | North Carolina | 37081 | 2482 | 106 |
270085 | 270085 | 2020-06-24 | Guilford | North Carolina | 37081 | 2527 | 110 |
273224 | 273224 | 2020-06-25 | Guilford | North Carolina | 37081 | 2586 | 111 |
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);