ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Rockingham" and state = "North Carolina" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
23104 | 23104 | 2020-03-31 | Rockingham | North Carolina | 37157 | 1 | 0 |
25298 | 25298 | 2020-04-01 | Rockingham | North Carolina | 37157 | 2 | 0 |
27563 | 27563 | 2020-04-02 | Rockingham | North Carolina | 37157 | 2 | 1 |
29890 | 29890 | 2020-04-03 | Rockingham | North Carolina | 37157 | 3 | 1 |
32277 | 32277 | 2020-04-04 | Rockingham | North Carolina | 37157 | 5 | 1 |
34709 | 34709 | 2020-04-05 | Rockingham | North Carolina | 37157 | 6 | 1 |
37178 | 37178 | 2020-04-06 | Rockingham | North Carolina | 37157 | 6 | 1 |
39694 | 39694 | 2020-04-07 | Rockingham | North Carolina | 37157 | 8 | 1 |
42251 | 42251 | 2020-04-08 | Rockingham | North Carolina | 37157 | 8 | 1 |
44835 | 44835 | 2020-04-09 | Rockingham | North Carolina | 37157 | 9 | 2 |
47448 | 47448 | 2020-04-10 | Rockingham | North Carolina | 37157 | 10 | 2 |
50103 | 50103 | 2020-04-11 | Rockingham | North Carolina | 37157 | 14 | 2 |
52776 | 52776 | 2020-04-12 | Rockingham | North Carolina | 37157 | 14 | 2 |
55460 | 55460 | 2020-04-13 | Rockingham | North Carolina | 37157 | 14 | 2 |
58160 | 58160 | 2020-04-14 | Rockingham | North Carolina | 37157 | 16 | 2 |
60874 | 60874 | 2020-04-15 | Rockingham | North Carolina | 37157 | 15 | 2 |
63600 | 63600 | 2020-04-16 | Rockingham | North Carolina | 37157 | 16 | 2 |
66343 | 66343 | 2020-04-17 | Rockingham | North Carolina | 37157 | 16 | 2 |
69100 | 69100 | 2020-04-18 | Rockingham | North Carolina | 37157 | 16 | 2 |
71866 | 71866 | 2020-04-19 | Rockingham | North Carolina | 37157 | 18 | 2 |
74641 | 74641 | 2020-04-20 | Rockingham | North Carolina | 37157 | 19 | 2 |
77422 | 77422 | 2020-04-21 | Rockingham | North Carolina | 37157 | 20 | 2 |
80211 | 80211 | 2020-04-22 | Rockingham | North Carolina | 37157 | 20 | 2 |
83010 | 83010 | 2020-04-23 | Rockingham | North Carolina | 37157 | 22 | 2 |
85814 | 85814 | 2020-04-24 | Rockingham | North Carolina | 37157 | 21 | 2 |
88627 | 88627 | 2020-04-25 | Rockingham | North Carolina | 37157 | 23 | 2 |
91442 | 91442 | 2020-04-26 | Rockingham | North Carolina | 37157 | 24 | 2 |
94268 | 94268 | 2020-04-27 | Rockingham | North Carolina | 37157 | 24 | 2 |
97105 | 97105 | 2020-04-28 | Rockingham | North Carolina | 37157 | 24 | 2 |
99953 | 99953 | 2020-04-29 | Rockingham | North Carolina | 37157 | 25 | 2 |
102806 | 102806 | 2020-04-30 | Rockingham | North Carolina | 37157 | 26 | 2 |
105668 | 105668 | 2020-05-01 | Rockingham | North Carolina | 37157 | 26 | 2 |
108535 | 108535 | 2020-05-02 | Rockingham | North Carolina | 37157 | 26 | 2 |
111408 | 111408 | 2020-05-03 | Rockingham | North Carolina | 37157 | 26 | 2 |
114289 | 114289 | 2020-05-04 | Rockingham | North Carolina | 37157 | 27 | 2 |
117169 | 117169 | 2020-05-05 | Rockingham | North Carolina | 37157 | 30 | 2 |
120130 | 120130 | 2020-05-06 | Rockingham | North Carolina | 37157 | 34 | 2 |
123105 | 123105 | 2020-05-07 | Rockingham | North Carolina | 37157 | 36 | 2 |
126088 | 126088 | 2020-05-08 | Rockingham | North Carolina | 37157 | 38 | 2 |
129077 | 129077 | 2020-05-09 | Rockingham | North Carolina | 37157 | 39 | 2 |
132066 | 132066 | 2020-05-10 | Rockingham | North Carolina | 37157 | 40 | 2 |
135057 | 135057 | 2020-05-11 | Rockingham | North Carolina | 37157 | 42 | 2 |
138047 | 138047 | 2020-05-12 | Rockingham | North Carolina | 37157 | 43 | 2 |
141043 | 141043 | 2020-05-13 | Rockingham | North Carolina | 37157 | 43 | 2 |
144038 | 144038 | 2020-05-14 | Rockingham | North Carolina | 37157 | 44 | 2 |
147039 | 147039 | 2020-05-15 | Rockingham | North Carolina | 37157 | 44 | 2 |
150046 | 150046 | 2020-05-16 | Rockingham | North Carolina | 37157 | 45 | 2 |
153056 | 153056 | 2020-05-17 | Rockingham | North Carolina | 37157 | 46 | 2 |
156073 | 156073 | 2020-05-18 | Rockingham | North Carolina | 37157 | 46 | 2 |
159092 | 159092 | 2020-05-19 | Rockingham | North Carolina | 37157 | 48 | 2 |
162119 | 162119 | 2020-05-20 | Rockingham | North Carolina | 37157 | 49 | 2 |
165148 | 165148 | 2020-05-21 | Rockingham | North Carolina | 37157 | 52 | 2 |
168183 | 168183 | 2020-05-22 | Rockingham | North Carolina | 37157 | 59 | 2 |
171222 | 171222 | 2020-05-23 | Rockingham | North Carolina | 37157 | 65 | 2 |
174264 | 174264 | 2020-05-24 | Rockingham | North Carolina | 37157 | 69 | 2 |
177308 | 177308 | 2020-05-25 | Rockingham | North Carolina | 37157 | 72 | 2 |
180351 | 180351 | 2020-05-26 | Rockingham | North Carolina | 37157 | 72 | 2 |
183399 | 183399 | 2020-05-27 | Rockingham | North Carolina | 37157 | 73 | 2 |
186456 | 186456 | 2020-05-28 | Rockingham | North Carolina | 37157 | 76 | 2 |
189516 | 189516 | 2020-05-29 | Rockingham | North Carolina | 37157 | 86 | 2 |
192580 | 192580 | 2020-05-30 | Rockingham | North Carolina | 37157 | 92 | 2 |
195650 | 195650 | 2020-05-31 | Rockingham | North Carolina | 37157 | 94 | 2 |
198723 | 198723 | 2020-06-01 | Rockingham | North Carolina | 37157 | 97 | 2 |
201797 | 201797 | 2020-06-02 | Rockingham | North Carolina | 37157 | 100 | 2 |
204874 | 204874 | 2020-06-03 | Rockingham | North Carolina | 37157 | 102 | 2 |
207955 | 207955 | 2020-06-04 | Rockingham | North Carolina | 37157 | 103 | 2 |
211037 | 211037 | 2020-06-05 | Rockingham | North Carolina | 37157 | 106 | 2 |
214121 | 214121 | 2020-06-06 | Rockingham | North Carolina | 37157 | 113 | 2 |
217211 | 217211 | 2020-06-07 | Rockingham | North Carolina | 37157 | 115 | 2 |
220303 | 220303 | 2020-06-08 | Rockingham | North Carolina | 37157 | 116 | 2 |
223397 | 223397 | 2020-06-09 | Rockingham | North Carolina | 37157 | 115 | 2 |
226497 | 226497 | 2020-06-10 | Rockingham | North Carolina | 37157 | 118 | 2 |
229601 | 229601 | 2020-06-11 | Rockingham | North Carolina | 37157 | 123 | 2 |
232706 | 232706 | 2020-06-12 | Rockingham | North Carolina | 37157 | 124 | 2 |
235811 | 235811 | 2020-06-13 | Rockingham | North Carolina | 37157 | 130 | 2 |
238919 | 238919 | 2020-06-14 | Rockingham | North Carolina | 37157 | 135 | 2 |
242028 | 242028 | 2020-06-15 | Rockingham | North Carolina | 37157 | 137 | 2 |
245140 | 245140 | 2020-06-16 | Rockingham | North Carolina | 37157 | 141 | 2 |
248253 | 248253 | 2020-06-17 | Rockingham | North Carolina | 37157 | 147 | 2 |
251368 | 251368 | 2020-06-18 | Rockingham | North Carolina | 37157 | 150 | 2 |
254483 | 254483 | 2020-06-19 | Rockingham | North Carolina | 37157 | 157 | 2 |
257606 | 257606 | 2020-06-20 | Rockingham | North Carolina | 37157 | 163 | 2 |
260733 | 260733 | 2020-06-21 | Rockingham | North Carolina | 37157 | 166 | 2 |
263861 | 263861 | 2020-06-22 | Rockingham | North Carolina | 37157 | 170 | 2 |
266989 | 266989 | 2020-06-23 | Rockingham | North Carolina | 37157 | 173 | 2 |
270123 | 270123 | 2020-06-24 | Rockingham | North Carolina | 37157 | 173 | 2 |
273262 | 273262 | 2020-06-25 | Rockingham | North Carolina | 37157 | 179 | 2 |
276408 | 276408 | 2020-06-26 | Rockingham | North Carolina | 37157 | 194 | 2 |
279556 | 279556 | 2020-06-27 | Rockingham | North Carolina | 37157 | 210 | 2 |
282702 | 282702 | 2020-06-28 | Rockingham | North Carolina | 37157 | 218 | 2 |
285847 | 285847 | 2020-06-29 | Rockingham | North Carolina | 37157 | 223 | 2 |
288997 | 288997 | 2020-06-30 | Rockingham | North Carolina | 37157 | 231 | 2 |
292149 | 292149 | 2020-07-01 | Rockingham | North Carolina | 37157 | 234 | 2 |
295304 | 295304 | 2020-07-02 | Rockingham | North Carolina | 37157 | 235 | 2 |
298464 | 298464 | 2020-07-03 | Rockingham | North Carolina | 37157 | 238 | 2 |
301627 | 301627 | 2020-07-04 | Rockingham | North Carolina | 37157 | 257 | 2 |
304790 | 304790 | 2020-07-05 | Rockingham | North Carolina | 37157 | 261 | 2 |
307957 | 307957 | 2020-07-06 | Rockingham | North Carolina | 37157 | 267 | 2 |
311125 | 311125 | 2020-07-07 | Rockingham | North Carolina | 37157 | 267 | 2 |
314296 | 314296 | 2020-07-08 | Rockingham | North Carolina | 37157 | 274 | 2 |
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);