ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,567 rows where county = "Rutherford" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
20978 | 20978 | 2020-03-30 | Rutherford | North Carolina | 37161 | 1 | 0 |
23106 | 23106 | 2020-03-31 | Rutherford | North Carolina | 37161 | 5 | 0 |
25300 | 25300 | 2020-04-01 | Rutherford | North Carolina | 37161 | 7 | 0 |
27565 | 27565 | 2020-04-02 | Rutherford | North Carolina | 37161 | 9 | 0 |
29892 | 29892 | 2020-04-03 | Rutherford | North Carolina | 37161 | 10 | 0 |
32279 | 32279 | 2020-04-04 | Rutherford | North Carolina | 37161 | 12 | 0 |
34711 | 34711 | 2020-04-05 | Rutherford | North Carolina | 37161 | 14 | 0 |
37180 | 37180 | 2020-04-06 | Rutherford | North Carolina | 37161 | 17 | 0 |
39696 | 39696 | 2020-04-07 | Rutherford | North Carolina | 37161 | 19 | 0 |
42253 | 42253 | 2020-04-08 | Rutherford | North Carolina | 37161 | 25 | 0 |
44837 | 44837 | 2020-04-09 | Rutherford | North Carolina | 37161 | 28 | 1 |
47450 | 47450 | 2020-04-10 | Rutherford | North Carolina | 37161 | 31 | 1 |
50105 | 50105 | 2020-04-11 | Rutherford | North Carolina | 37161 | 37 | 2 |
52778 | 52778 | 2020-04-12 | Rutherford | North Carolina | 37161 | 37 | 2 |
55462 | 55462 | 2020-04-13 | Rutherford | North Carolina | 37161 | 40 | 2 |
58162 | 58162 | 2020-04-14 | Rutherford | North Carolina | 37161 | 43 | 2 |
60876 | 60876 | 2020-04-15 | Rutherford | North Carolina | 37161 | 45 | 2 |
63602 | 63602 | 2020-04-16 | Rutherford | North Carolina | 37161 | 55 | 2 |
66345 | 66345 | 2020-04-17 | Rutherford | North Carolina | 37161 | 59 | 2 |
69102 | 69102 | 2020-04-18 | Rutherford | North Carolina | 37161 | 65 | 2 |
71868 | 71868 | 2020-04-19 | Rutherford | North Carolina | 37161 | 75 | 2 |
74643 | 74643 | 2020-04-20 | Rutherford | North Carolina | 37161 | 84 | 2 |
77424 | 77424 | 2020-04-21 | Rutherford | North Carolina | 37161 | 80 | 3 |
80213 | 80213 | 2020-04-22 | Rutherford | North Carolina | 37161 | 80 | 4 |
83012 | 83012 | 2020-04-23 | Rutherford | North Carolina | 37161 | 92 | 4 |
85816 | 85816 | 2020-04-24 | Rutherford | North Carolina | 37161 | 105 | 4 |
88629 | 88629 | 2020-04-25 | Rutherford | North Carolina | 37161 | 108 | 6 |
91444 | 91444 | 2020-04-26 | Rutherford | North Carolina | 37161 | 116 | 6 |
94270 | 94270 | 2020-04-27 | Rutherford | North Carolina | 37161 | 119 | 6 |
97107 | 97107 | 2020-04-28 | Rutherford | North Carolina | 37161 | 120 | 6 |
99955 | 99955 | 2020-04-29 | Rutherford | North Carolina | 37161 | 123 | 6 |
102808 | 102808 | 2020-04-30 | Rutherford | North Carolina | 37161 | 139 | 6 |
105670 | 105670 | 2020-05-01 | Rutherford | North Carolina | 37161 | 140 | 6 |
108537 | 108537 | 2020-05-02 | Rutherford | North Carolina | 37161 | 142 | 6 |
111410 | 111410 | 2020-05-03 | Rutherford | North Carolina | 37161 | 145 | 6 |
114291 | 114291 | 2020-05-04 | Rutherford | North Carolina | 37161 | 146 | 6 |
117171 | 117171 | 2020-05-05 | Rutherford | North Carolina | 37161 | 145 | 7 |
120132 | 120132 | 2020-05-06 | Rutherford | North Carolina | 37161 | 145 | 7 |
123107 | 123107 | 2020-05-07 | Rutherford | North Carolina | 37161 | 148 | 7 |
126090 | 126090 | 2020-05-08 | Rutherford | North Carolina | 37161 | 149 | 7 |
129079 | 129079 | 2020-05-09 | Rutherford | North Carolina | 37161 | 151 | 7 |
132068 | 132068 | 2020-05-10 | Rutherford | North Carolina | 37161 | 151 | 7 |
135059 | 135059 | 2020-05-11 | Rutherford | North Carolina | 37161 | 154 | 7 |
138049 | 138049 | 2020-05-12 | Rutherford | North Carolina | 37161 | 152 | 7 |
141045 | 141045 | 2020-05-13 | Rutherford | North Carolina | 37161 | 154 | 7 |
144040 | 144040 | 2020-05-14 | Rutherford | North Carolina | 37161 | 153 | 7 |
147041 | 147041 | 2020-05-15 | Rutherford | North Carolina | 37161 | 153 | 7 |
150048 | 150048 | 2020-05-16 | Rutherford | North Carolina | 37161 | 153 | 7 |
153058 | 153058 | 2020-05-17 | Rutherford | North Carolina | 37161 | 153 | 7 |
156075 | 156075 | 2020-05-18 | Rutherford | North Carolina | 37161 | 155 | 7 |
159094 | 159094 | 2020-05-19 | Rutherford | North Carolina | 37161 | 155 | 7 |
162121 | 162121 | 2020-05-20 | Rutherford | North Carolina | 37161 | 156 | 7 |
165150 | 165150 | 2020-05-21 | Rutherford | North Carolina | 37161 | 158 | 7 |
168185 | 168185 | 2020-05-22 | Rutherford | North Carolina | 37161 | 161 | 7 |
171224 | 171224 | 2020-05-23 | Rutherford | North Carolina | 37161 | 161 | 7 |
174266 | 174266 | 2020-05-24 | Rutherford | North Carolina | 37161 | 164 | 7 |
177310 | 177310 | 2020-05-25 | Rutherford | North Carolina | 37161 | 171 | 7 |
180353 | 180353 | 2020-05-26 | Rutherford | North Carolina | 37161 | 171 | 7 |
183401 | 183401 | 2020-05-27 | Rutherford | North Carolina | 37161 | 174 | 7 |
186458 | 186458 | 2020-05-28 | Rutherford | North Carolina | 37161 | 174 | 7 |
189518 | 189518 | 2020-05-29 | Rutherford | North Carolina | 37161 | 176 | 7 |
192582 | 192582 | 2020-05-30 | Rutherford | North Carolina | 37161 | 182 | 7 |
195652 | 195652 | 2020-05-31 | Rutherford | North Carolina | 37161 | 182 | 7 |
198725 | 198725 | 2020-06-01 | Rutherford | North Carolina | 37161 | 186 | 7 |
201799 | 201799 | 2020-06-02 | Rutherford | North Carolina | 37161 | 186 | 7 |
204876 | 204876 | 2020-06-03 | Rutherford | North Carolina | 37161 | 188 | 7 |
207957 | 207957 | 2020-06-04 | Rutherford | North Carolina | 37161 | 188 | 7 |
211039 | 211039 | 2020-06-05 | Rutherford | North Carolina | 37161 | 196 | 7 |
214123 | 214123 | 2020-06-06 | Rutherford | North Carolina | 37161 | 196 | 7 |
217213 | 217213 | 2020-06-07 | Rutherford | North Carolina | 37161 | 198 | 7 |
220305 | 220305 | 2020-06-08 | Rutherford | North Carolina | 37161 | 200 | 7 |
223399 | 223399 | 2020-06-09 | Rutherford | North Carolina | 37161 | 200 | 7 |
226499 | 226499 | 2020-06-10 | Rutherford | North Carolina | 37161 | 202 | 7 |
229603 | 229603 | 2020-06-11 | Rutherford | North Carolina | 37161 | 202 | 7 |
232708 | 232708 | 2020-06-12 | Rutherford | North Carolina | 37161 | 221 | 7 |
235813 | 235813 | 2020-06-13 | Rutherford | North Carolina | 37161 | 221 | 7 |
238921 | 238921 | 2020-06-14 | Rutherford | North Carolina | 37161 | 226 | 7 |
242030 | 242030 | 2020-06-15 | Rutherford | North Carolina | 37161 | 228 | 9 |
245142 | 245142 | 2020-06-16 | Rutherford | North Carolina | 37161 | 228 | 9 |
248255 | 248255 | 2020-06-17 | Rutherford | North Carolina | 37161 | 233 | 9 |
251370 | 251370 | 2020-06-18 | Rutherford | North Carolina | 37161 | 233 | 9 |
254485 | 254485 | 2020-06-19 | Rutherford | North Carolina | 37161 | 241 | 9 |
257608 | 257608 | 2020-06-20 | Rutherford | North Carolina | 37161 | 242 | 9 |
260735 | 260735 | 2020-06-21 | Rutherford | North Carolina | 37161 | 255 | 9 |
263863 | 263863 | 2020-06-22 | Rutherford | North Carolina | 37161 | 263 | 9 |
266991 | 266991 | 2020-06-23 | Rutherford | North Carolina | 37161 | 263 | 9 |
270125 | 270125 | 2020-06-24 | Rutherford | North Carolina | 37161 | 269 | 9 |
273264 | 273264 | 2020-06-25 | Rutherford | North Carolina | 37161 | 269 | 9 |
276410 | 276410 | 2020-06-26 | Rutherford | North Carolina | 37161 | 281 | 9 |
279558 | 279558 | 2020-06-27 | Rutherford | North Carolina | 37161 | 281 | 9 |
282704 | 282704 | 2020-06-28 | Rutherford | North Carolina | 37161 | 281 | 9 |
285849 | 285849 | 2020-06-29 | Rutherford | North Carolina | 37161 | 306 | 9 |
288999 | 288999 | 2020-06-30 | Rutherford | North Carolina | 37161 | 308 | 9 |
292151 | 292151 | 2020-07-01 | Rutherford | North Carolina | 37161 | 308 | 9 |
295306 | 295306 | 2020-07-02 | Rutherford | North Carolina | 37161 | 317 | 10 |
298466 | 298466 | 2020-07-03 | Rutherford | North Carolina | 37161 | 317 | 10 |
301629 | 301629 | 2020-07-04 | Rutherford | North Carolina | 37161 | 324 | 10 |
304792 | 304792 | 2020-07-05 | Rutherford | North Carolina | 37161 | 328 | 10 |
307959 | 307959 | 2020-07-06 | Rutherford | North Carolina | 37161 | 360 | 10 |
311127 | 311127 | 2020-07-07 | Rutherford | North Carolina | 37161 | 360 | 10 |
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);