ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Randolph" and fips = 37151 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 |
---|---|---|---|---|---|---|---|
10384 | 10384 | 2020-03-24 | Randolph | North Carolina | 37151 | 2 | 0 |
11829 | 11829 | 2020-03-25 | Randolph | North Carolina | 37151 | 3 | 0 |
13433 | 13433 | 2020-03-26 | Randolph | North Carolina | 37151 | 3 | 0 |
15169 | 15169 | 2020-03-27 | Randolph | North Carolina | 37151 | 5 | 0 |
17003 | 17003 | 2020-03-28 | Randolph | North Carolina | 37151 | 9 | 0 |
18935 | 18935 | 2020-03-29 | Randolph | North Carolina | 37151 | 15 | 0 |
20975 | 20975 | 2020-03-30 | Randolph | North Carolina | 37151 | 16 | 0 |
23102 | 23102 | 2020-03-31 | Randolph | North Carolina | 37151 | 17 | 0 |
25296 | 25296 | 2020-04-01 | Randolph | North Carolina | 37151 | 17 | 0 |
27561 | 27561 | 2020-04-02 | Randolph | North Carolina | 37151 | 19 | 0 |
29888 | 29888 | 2020-04-03 | Randolph | North Carolina | 37151 | 19 | 1 |
32275 | 32275 | 2020-04-04 | Randolph | North Carolina | 37151 | 26 | 1 |
34707 | 34707 | 2020-04-05 | Randolph | North Carolina | 37151 | 29 | 1 |
37176 | 37176 | 2020-04-06 | Randolph | North Carolina | 37151 | 33 | 1 |
39691 | 39691 | 2020-04-07 | Randolph | North Carolina | 37151 | 35 | 1 |
42248 | 42248 | 2020-04-08 | Randolph | North Carolina | 37151 | 37 | 2 |
44832 | 44832 | 2020-04-09 | Randolph | North Carolina | 37151 | 42 | 2 |
47445 | 47445 | 2020-04-10 | Randolph | North Carolina | 37151 | 46 | 2 |
50100 | 50100 | 2020-04-11 | Randolph | North Carolina | 37151 | 51 | 2 |
52773 | 52773 | 2020-04-12 | Randolph | North Carolina | 37151 | 50 | 2 |
55457 | 55457 | 2020-04-13 | Randolph | North Carolina | 37151 | 53 | 2 |
58157 | 58157 | 2020-04-14 | Randolph | North Carolina | 37151 | 55 | 2 |
60871 | 60871 | 2020-04-15 | Randolph | North Carolina | 37151 | 56 | 2 |
63597 | 63597 | 2020-04-16 | Randolph | North Carolina | 37151 | 63 | 2 |
66340 | 66340 | 2020-04-17 | Randolph | North Carolina | 37151 | 67 | 2 |
69097 | 69097 | 2020-04-18 | Randolph | North Carolina | 37151 | 69 | 2 |
71863 | 71863 | 2020-04-19 | Randolph | North Carolina | 37151 | 74 | 2 |
74638 | 74638 | 2020-04-20 | Randolph | North Carolina | 37151 | 77 | 2 |
77419 | 77419 | 2020-04-21 | Randolph | North Carolina | 37151 | 78 | 2 |
80208 | 80208 | 2020-04-22 | Randolph | North Carolina | 37151 | 82 | 2 |
83007 | 83007 | 2020-04-23 | Randolph | North Carolina | 37151 | 97 | 2 |
85811 | 85811 | 2020-04-24 | Randolph | North Carolina | 37151 | 107 | 2 |
88624 | 88624 | 2020-04-25 | Randolph | North Carolina | 37151 | 118 | 2 |
91439 | 91439 | 2020-04-26 | Randolph | North Carolina | 37151 | 128 | 3 |
94265 | 94265 | 2020-04-27 | Randolph | North Carolina | 37151 | 137 | 3 |
97102 | 97102 | 2020-04-28 | Randolph | North Carolina | 37151 | 154 | 3 |
99950 | 99950 | 2020-04-29 | Randolph | North Carolina | 37151 | 168 | 3 |
102803 | 102803 | 2020-04-30 | Randolph | North Carolina | 37151 | 185 | 3 |
105665 | 105665 | 2020-05-01 | Randolph | North Carolina | 37151 | 209 | 3 |
108532 | 108532 | 2020-05-02 | Randolph | North Carolina | 37151 | 228 | 3 |
111405 | 111405 | 2020-05-03 | Randolph | North Carolina | 37151 | 238 | 3 |
114286 | 114286 | 2020-05-04 | Randolph | North Carolina | 37151 | 242 | 3 |
117166 | 117166 | 2020-05-05 | Randolph | North Carolina | 37151 | 255 | 4 |
120127 | 120127 | 2020-05-06 | Randolph | North Carolina | 37151 | 275 | 4 |
123102 | 123102 | 2020-05-07 | Randolph | North Carolina | 37151 | 290 | 5 |
126085 | 126085 | 2020-05-08 | Randolph | North Carolina | 37151 | 307 | 5 |
129074 | 129074 | 2020-05-09 | Randolph | North Carolina | 37151 | 317 | 5 |
132063 | 132063 | 2020-05-10 | Randolph | North Carolina | 37151 | 338 | 6 |
135054 | 135054 | 2020-05-11 | Randolph | North Carolina | 37151 | 354 | 6 |
138044 | 138044 | 2020-05-12 | Randolph | North Carolina | 37151 | 355 | 6 |
141040 | 141040 | 2020-05-13 | Randolph | North Carolina | 37151 | 369 | 6 |
144035 | 144035 | 2020-05-14 | Randolph | North Carolina | 37151 | 392 | 6 |
147036 | 147036 | 2020-05-15 | Randolph | North Carolina | 37151 | 422 | 6 |
150043 | 150043 | 2020-05-16 | Randolph | North Carolina | 37151 | 438 | 6 |
153053 | 153053 | 2020-05-17 | Randolph | North Carolina | 37151 | 455 | 6 |
156070 | 156070 | 2020-05-18 | Randolph | North Carolina | 37151 | 461 | 6 |
159089 | 159089 | 2020-05-19 | Randolph | North Carolina | 37151 | 469 | 6 |
162116 | 162116 | 2020-05-20 | Randolph | North Carolina | 37151 | 486 | 6 |
165145 | 165145 | 2020-05-21 | Randolph | North Carolina | 37151 | 502 | 6 |
168180 | 168180 | 2020-05-22 | Randolph | North Carolina | 37151 | 528 | 7 |
171219 | 171219 | 2020-05-23 | Randolph | North Carolina | 37151 | 549 | 8 |
174261 | 174261 | 2020-05-24 | Randolph | North Carolina | 37151 | 567 | 9 |
177305 | 177305 | 2020-05-25 | Randolph | North Carolina | 37151 | 601 | 10 |
180348 | 180348 | 2020-05-26 | Randolph | North Carolina | 37151 | 613 | 10 |
183396 | 183396 | 2020-05-27 | Randolph | North Carolina | 37151 | 624 | 12 |
186453 | 186453 | 2020-05-28 | Randolph | North Carolina | 37151 | 639 | 12 |
189513 | 189513 | 2020-05-29 | Randolph | North Carolina | 37151 | 651 | 12 |
192577 | 192577 | 2020-05-30 | Randolph | North Carolina | 37151 | 659 | 13 |
195647 | 195647 | 2020-05-31 | Randolph | North Carolina | 37151 | 664 | 13 |
198720 | 198720 | 2020-06-01 | Randolph | North Carolina | 37151 | 671 | 13 |
201794 | 201794 | 2020-06-02 | Randolph | North Carolina | 37151 | 678 | 13 |
204871 | 204871 | 2020-06-03 | Randolph | North Carolina | 37151 | 697 | 13 |
207952 | 207952 | 2020-06-04 | Randolph | North Carolina | 37151 | 730 | 14 |
211034 | 211034 | 2020-06-05 | Randolph | North Carolina | 37151 | 751 | 14 |
214118 | 214118 | 2020-06-06 | Randolph | North Carolina | 37151 | 779 | 15 |
217208 | 217208 | 2020-06-07 | Randolph | North Carolina | 37151 | 792 | 15 |
220300 | 220300 | 2020-06-08 | Randolph | North Carolina | 37151 | 801 | 15 |
223394 | 223394 | 2020-06-09 | Randolph | North Carolina | 37151 | 809 | 15 |
226494 | 226494 | 2020-06-10 | Randolph | North Carolina | 37151 | 842 | 17 |
229598 | 229598 | 2020-06-11 | Randolph | North Carolina | 37151 | 866 | 17 |
232703 | 232703 | 2020-06-12 | Randolph | North Carolina | 37151 | 882 | 18 |
235808 | 235808 | 2020-06-13 | Randolph | North Carolina | 37151 | 908 | 18 |
238916 | 238916 | 2020-06-14 | Randolph | North Carolina | 37151 | 921 | 18 |
242025 | 242025 | 2020-06-15 | Randolph | North Carolina | 37151 | 927 | 18 |
245137 | 245137 | 2020-06-16 | Randolph | North Carolina | 37151 | 947 | 20 |
248250 | 248250 | 2020-06-17 | Randolph | North Carolina | 37151 | 969 | 21 |
251365 | 251365 | 2020-06-18 | Randolph | North Carolina | 37151 | 997 | 22 |
254480 | 254480 | 2020-06-19 | Randolph | North Carolina | 37151 | 1013 | 23 |
257603 | 257603 | 2020-06-20 | Randolph | North Carolina | 37151 | 1032 | 24 |
260730 | 260730 | 2020-06-21 | Randolph | North Carolina | 37151 | 1054 | 26 |
263858 | 263858 | 2020-06-22 | Randolph | North Carolina | 37151 | 1058 | 27 |
266986 | 266986 | 2020-06-23 | Randolph | North Carolina | 37151 | 1068 | 27 |
270120 | 270120 | 2020-06-24 | Randolph | North Carolina | 37151 | 1077 | 28 |
273259 | 273259 | 2020-06-25 | Randolph | North Carolina | 37151 | 1090 | 28 |
276405 | 276405 | 2020-06-26 | Randolph | North Carolina | 37151 | 1116 | 29 |
279553 | 279553 | 2020-06-27 | Randolph | North Carolina | 37151 | 1137 | 29 |
282699 | 282699 | 2020-06-28 | Randolph | North Carolina | 37151 | 1149 | 29 |
285844 | 285844 | 2020-06-29 | Randolph | North Carolina | 37151 | 1155 | 29 |
288994 | 288994 | 2020-06-30 | Randolph | North Carolina | 37151 | 1174 | 29 |
292146 | 292146 | 2020-07-01 | Randolph | North Carolina | 37151 | 1206 | 30 |
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);