ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Newberry" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
6901 | 6901 | 2020-03-21 | Newberry | South Carolina | 45071 | 1 | 0 |
8022 | 8022 | 2020-03-22 | Newberry | South Carolina | 45071 | 1 | 0 |
9235 | 9235 | 2020-03-23 | Newberry | South Carolina | 45071 | 1 | 0 |
10561 | 10561 | 2020-03-24 | Newberry | South Carolina | 45071 | 1 | 0 |
12033 | 12033 | 2020-03-25 | Newberry | South Carolina | 45071 | 1 | 0 |
13655 | 13655 | 2020-03-26 | Newberry | South Carolina | 45071 | 1 | 0 |
15402 | 15402 | 2020-03-27 | Newberry | South Carolina | 45071 | 1 | 0 |
17257 | 17257 | 2020-03-28 | Newberry | South Carolina | 45071 | 2 | 0 |
19197 | 19197 | 2020-03-29 | Newberry | South Carolina | 45071 | 2 | 0 |
21249 | 21249 | 2020-03-30 | Newberry | South Carolina | 45071 | 2 | 0 |
23387 | 23387 | 2020-03-31 | Newberry | South Carolina | 45071 | 2 | 0 |
25585 | 25585 | 2020-04-01 | Newberry | South Carolina | 45071 | 2 | 0 |
27861 | 27861 | 2020-04-02 | Newberry | South Carolina | 45071 | 4 | 0 |
30196 | 30196 | 2020-04-03 | Newberry | South Carolina | 45071 | 5 | 0 |
32587 | 32587 | 2020-04-04 | Newberry | South Carolina | 45071 | 8 | 0 |
35023 | 35023 | 2020-04-05 | Newberry | South Carolina | 45071 | 7 | 0 |
37498 | 37498 | 2020-04-06 | Newberry | South Carolina | 45071 | 7 | 0 |
40021 | 40021 | 2020-04-07 | Newberry | South Carolina | 45071 | 7 | 0 |
42581 | 42581 | 2020-04-08 | Newberry | South Carolina | 45071 | 9 | 1 |
45167 | 45167 | 2020-04-09 | Newberry | South Carolina | 45071 | 11 | 1 |
47784 | 47784 | 2020-04-10 | Newberry | South Carolina | 45071 | 13 | 1 |
50441 | 50441 | 2020-04-11 | Newberry | South Carolina | 45071 | 13 | 1 |
53114 | 53114 | 2020-04-12 | Newberry | South Carolina | 45071 | 13 | 1 |
55799 | 55799 | 2020-04-13 | Newberry | South Carolina | 45071 | 13 | 1 |
58502 | 58502 | 2020-04-14 | Newberry | South Carolina | 45071 | 15 | 1 |
61217 | 61217 | 2020-04-15 | Newberry | South Carolina | 45071 | 16 | 1 |
63943 | 63943 | 2020-04-16 | Newberry | South Carolina | 45071 | 22 | 1 |
66689 | 66689 | 2020-04-17 | Newberry | South Carolina | 45071 | 23 | 1 |
69447 | 69447 | 2020-04-18 | Newberry | South Carolina | 45071 | 23 | 1 |
72214 | 72214 | 2020-04-19 | Newberry | South Carolina | 45071 | 21 | 1 |
74989 | 74989 | 2020-04-20 | Newberry | South Carolina | 45071 | 20 | 1 |
77771 | 77771 | 2020-04-21 | Newberry | South Carolina | 45071 | 22 | 1 |
80561 | 80561 | 2020-04-22 | Newberry | South Carolina | 45071 | 21 | 1 |
83360 | 83360 | 2020-04-23 | Newberry | South Carolina | 45071 | 21 | 1 |
86164 | 86164 | 2020-04-24 | Newberry | South Carolina | 45071 | 22 | 1 |
88978 | 88978 | 2020-04-25 | Newberry | South Carolina | 45071 | 22 | 1 |
91794 | 91794 | 2020-04-26 | Newberry | South Carolina | 45071 | 23 | 1 |
94621 | 94621 | 2020-04-27 | Newberry | South Carolina | 45071 | 23 | 1 |
97460 | 97460 | 2020-04-28 | Newberry | South Carolina | 45071 | 23 | 1 |
100309 | 100309 | 2020-04-29 | Newberry | South Carolina | 45071 | 24 | 1 |
103162 | 103162 | 2020-04-30 | Newberry | South Carolina | 45071 | 26 | 1 |
106025 | 106025 | 2020-05-01 | Newberry | South Carolina | 45071 | 27 | 1 |
108892 | 108892 | 2020-05-02 | Newberry | South Carolina | 45071 | 28 | 1 |
111766 | 111766 | 2020-05-03 | Newberry | South Carolina | 45071 | 30 | 1 |
114648 | 114648 | 2020-05-04 | Newberry | South Carolina | 45071 | 30 | 1 |
117604 | 117604 | 2020-05-05 | Newberry | South Carolina | 45071 | 31 | 1 |
120566 | 120566 | 2020-05-06 | Newberry | South Carolina | 45071 | 31 | 1 |
123544 | 123544 | 2020-05-07 | Newberry | South Carolina | 45071 | 31 | 1 |
126527 | 126527 | 2020-05-08 | Newberry | South Carolina | 45071 | 32 | 1 |
129516 | 129516 | 2020-05-09 | Newberry | South Carolina | 45071 | 31 | 1 |
132505 | 132505 | 2020-05-10 | Newberry | South Carolina | 45071 | 31 | 1 |
135496 | 135496 | 2020-05-11 | Newberry | South Carolina | 45071 | 31 | 1 |
138486 | 138486 | 2020-05-12 | Newberry | South Carolina | 45071 | 32 | 1 |
141482 | 141482 | 2020-05-13 | Newberry | South Carolina | 45071 | 31 | 1 |
144478 | 144478 | 2020-05-14 | Newberry | South Carolina | 45071 | 30 | 1 |
147479 | 147479 | 2020-05-15 | Newberry | South Carolina | 45071 | 30 | 1 |
150487 | 150487 | 2020-05-16 | Newberry | South Carolina | 45071 | 31 | 1 |
153498 | 153498 | 2020-05-17 | Newberry | South Carolina | 45071 | 31 | 1 |
156515 | 156515 | 2020-05-18 | Newberry | South Carolina | 45071 | 33 | 1 |
159536 | 159536 | 2020-05-19 | Newberry | South Carolina | 45071 | 33 | 1 |
162563 | 162563 | 2020-05-20 | Newberry | South Carolina | 45071 | 33 | 1 |
165592 | 165592 | 2020-05-21 | Newberry | South Carolina | 45071 | 36 | 1 |
168628 | 168628 | 2020-05-22 | Newberry | South Carolina | 45071 | 44 | 1 |
171667 | 171667 | 2020-05-23 | Newberry | South Carolina | 45071 | 44 | 1 |
174709 | 174709 | 2020-05-24 | Newberry | South Carolina | 45071 | 46 | 1 |
177753 | 177753 | 2020-05-25 | Newberry | South Carolina | 45071 | 46 | 1 |
180796 | 180796 | 2020-05-26 | Newberry | South Carolina | 45071 | 48 | 1 |
183846 | 183846 | 2020-05-27 | Newberry | South Carolina | 45071 | 49 | 1 |
186903 | 186903 | 2020-05-28 | Newberry | South Carolina | 45071 | 51 | 1 |
189965 | 189965 | 2020-05-29 | Newberry | South Carolina | 45071 | 55 | 1 |
193030 | 193030 | 2020-05-30 | Newberry | South Carolina | 45071 | 60 | 1 |
196099 | 196099 | 2020-05-31 | Newberry | South Carolina | 45071 | 63 | 1 |
199172 | 199172 | 2020-06-01 | Newberry | South Carolina | 45071 | 62 | 1 |
202247 | 202247 | 2020-06-02 | Newberry | South Carolina | 45071 | 63 | 1 |
205324 | 205324 | 2020-06-03 | Newberry | South Carolina | 45071 | 64 | 1 |
208405 | 208405 | 2020-06-04 | Newberry | South Carolina | 45071 | 67 | 1 |
211487 | 211487 | 2020-06-05 | Newberry | South Carolina | 45071 | 71 | 1 |
214573 | 214573 | 2020-06-06 | Newberry | South Carolina | 45071 | 77 | 1 |
217663 | 217663 | 2020-06-07 | Newberry | South Carolina | 45071 | 79 | 1 |
220755 | 220755 | 2020-06-08 | Newberry | South Carolina | 45071 | 82 | 1 |
223850 | 223850 | 2020-06-09 | Newberry | South Carolina | 45071 | 87 | 1 |
226950 | 226950 | 2020-06-10 | Newberry | South Carolina | 45071 | 88 | 2 |
230054 | 230054 | 2020-06-11 | Newberry | South Carolina | 45071 | 90 | 2 |
233159 | 233159 | 2020-06-12 | Newberry | South Carolina | 45071 | 93 | 2 |
236264 | 236264 | 2020-06-13 | Newberry | South Carolina | 45071 | 95 | 2 |
239372 | 239372 | 2020-06-14 | Newberry | South Carolina | 45071 | 99 | 2 |
242481 | 242481 | 2020-06-15 | Newberry | South Carolina | 45071 | 105 | 2 |
245593 | 245593 | 2020-06-16 | Newberry | South Carolina | 45071 | 108 | 2 |
248706 | 248706 | 2020-06-17 | Newberry | South Carolina | 45071 | 110 | 2 |
251821 | 251821 | 2020-06-18 | Newberry | South Carolina | 45071 | 116 | 2 |
254936 | 254936 | 2020-06-19 | Newberry | South Carolina | 45071 | 117 | 3 |
258062 | 258062 | 2020-06-20 | Newberry | South Carolina | 45071 | 125 | 3 |
261189 | 261189 | 2020-06-21 | Newberry | South Carolina | 45071 | 132 | 3 |
264317 | 264317 | 2020-06-22 | Newberry | South Carolina | 45071 | 137 | 3 |
267445 | 267445 | 2020-06-23 | Newberry | South Carolina | 45071 | 143 | 3 |
270579 | 270579 | 2020-06-24 | Newberry | South Carolina | 45071 | 175 | 4 |
273718 | 273718 | 2020-06-25 | Newberry | South Carolina | 45071 | 180 | 4 |
276865 | 276865 | 2020-06-26 | Newberry | South Carolina | 45071 | 187 | 4 |
280013 | 280013 | 2020-06-27 | Newberry | South Carolina | 45071 | 190 | 4 |
283159 | 283159 | 2020-06-28 | Newberry | South Carolina | 45071 | 221 | 4 |
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);