ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Orangeburg" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5892 | 5892 | 2020-03-20 | Orangeburg | South Carolina | 45075 | 2 | 0 |
6902 | 6902 | 2020-03-21 | Orangeburg | South Carolina | 45075 | 3 | 0 |
8023 | 8023 | 2020-03-22 | Orangeburg | South Carolina | 45075 | 3 | 0 |
9237 | 9237 | 2020-03-23 | Orangeburg | South Carolina | 45075 | 8 | 0 |
10563 | 10563 | 2020-03-24 | Orangeburg | South Carolina | 45075 | 8 | 0 |
12035 | 12035 | 2020-03-25 | Orangeburg | South Carolina | 45075 | 9 | 0 |
13657 | 13657 | 2020-03-26 | Orangeburg | South Carolina | 45075 | 11 | 0 |
15404 | 15404 | 2020-03-27 | Orangeburg | South Carolina | 45075 | 12 | 0 |
17259 | 17259 | 2020-03-28 | Orangeburg | South Carolina | 45075 | 14 | 0 |
19199 | 19199 | 2020-03-29 | Orangeburg | South Carolina | 45075 | 16 | 0 |
21251 | 21251 | 2020-03-30 | Orangeburg | South Carolina | 45075 | 21 | 0 |
23389 | 23389 | 2020-03-31 | Orangeburg | South Carolina | 45075 | 22 | 0 |
25587 | 25587 | 2020-04-01 | Orangeburg | South Carolina | 45075 | 24 | 0 |
27863 | 27863 | 2020-04-02 | Orangeburg | South Carolina | 45075 | 24 | 0 |
30198 | 30198 | 2020-04-03 | Orangeburg | South Carolina | 45075 | 25 | 0 |
32589 | 32589 | 2020-04-04 | Orangeburg | South Carolina | 45075 | 26 | 0 |
35025 | 35025 | 2020-04-05 | Orangeburg | South Carolina | 45075 | 27 | 0 |
37500 | 37500 | 2020-04-06 | Orangeburg | South Carolina | 45075 | 28 | 0 |
40023 | 40023 | 2020-04-07 | Orangeburg | South Carolina | 45075 | 30 | 0 |
42583 | 42583 | 2020-04-08 | Orangeburg | South Carolina | 45075 | 31 | 0 |
45169 | 45169 | 2020-04-09 | Orangeburg | South Carolina | 45075 | 35 | 0 |
47786 | 47786 | 2020-04-10 | Orangeburg | South Carolina | 45075 | 37 | 0 |
50443 | 50443 | 2020-04-11 | Orangeburg | South Carolina | 45075 | 37 | 0 |
53116 | 53116 | 2020-04-12 | Orangeburg | South Carolina | 45075 | 37 | 0 |
55801 | 55801 | 2020-04-13 | Orangeburg | South Carolina | 45075 | 37 | 0 |
58504 | 58504 | 2020-04-14 | Orangeburg | South Carolina | 45075 | 38 | 0 |
61219 | 61219 | 2020-04-15 | Orangeburg | South Carolina | 45075 | 38 | 0 |
63945 | 63945 | 2020-04-16 | Orangeburg | South Carolina | 45075 | 40 | 0 |
66691 | 66691 | 2020-04-17 | Orangeburg | South Carolina | 45075 | 41 | 0 |
69449 | 69449 | 2020-04-18 | Orangeburg | South Carolina | 45075 | 41 | 0 |
72216 | 72216 | 2020-04-19 | Orangeburg | South Carolina | 45075 | 43 | 0 |
74991 | 74991 | 2020-04-20 | Orangeburg | South Carolina | 45075 | 44 | 0 |
77773 | 77773 | 2020-04-21 | Orangeburg | South Carolina | 45075 | 49 | 0 |
80563 | 80563 | 2020-04-22 | Orangeburg | South Carolina | 45075 | 51 | 0 |
83362 | 83362 | 2020-04-23 | Orangeburg | South Carolina | 45075 | 52 | 0 |
86166 | 86166 | 2020-04-24 | Orangeburg | South Carolina | 45075 | 53 | 0 |
88980 | 88980 | 2020-04-25 | Orangeburg | South Carolina | 45075 | 56 | 1 |
91796 | 91796 | 2020-04-26 | Orangeburg | South Carolina | 45075 | 61 | 1 |
94623 | 94623 | 2020-04-27 | Orangeburg | South Carolina | 45075 | 60 | 1 |
97462 | 97462 | 2020-04-28 | Orangeburg | South Carolina | 45075 | 63 | 1 |
100311 | 100311 | 2020-04-29 | Orangeburg | South Carolina | 45075 | 68 | 1 |
103164 | 103164 | 2020-04-30 | Orangeburg | South Carolina | 45075 | 72 | 1 |
106027 | 106027 | 2020-05-01 | Orangeburg | South Carolina | 45075 | 77 | 2 |
108894 | 108894 | 2020-05-02 | Orangeburg | South Carolina | 45075 | 81 | 2 |
111768 | 111768 | 2020-05-03 | Orangeburg | South Carolina | 45075 | 87 | 2 |
114650 | 114650 | 2020-05-04 | Orangeburg | South Carolina | 45075 | 92 | 2 |
117606 | 117606 | 2020-05-05 | Orangeburg | South Carolina | 45075 | 94 | 2 |
120568 | 120568 | 2020-05-06 | Orangeburg | South Carolina | 45075 | 95 | 2 |
123546 | 123546 | 2020-05-07 | Orangeburg | South Carolina | 45075 | 95 | 2 |
126529 | 126529 | 2020-05-08 | Orangeburg | South Carolina | 45075 | 99 | 2 |
129518 | 129518 | 2020-05-09 | Orangeburg | South Carolina | 45075 | 99 | 2 |
132507 | 132507 | 2020-05-10 | Orangeburg | South Carolina | 45075 | 101 | 2 |
135498 | 135498 | 2020-05-11 | Orangeburg | South Carolina | 45075 | 101 | 2 |
138488 | 138488 | 2020-05-12 | Orangeburg | South Carolina | 45075 | 104 | 2 |
141484 | 141484 | 2020-05-13 | Orangeburg | South Carolina | 45075 | 106 | 2 |
144480 | 144480 | 2020-05-14 | Orangeburg | South Carolina | 45075 | 108 | 2 |
147481 | 147481 | 2020-05-15 | Orangeburg | South Carolina | 45075 | 108 | 2 |
150489 | 150489 | 2020-05-16 | Orangeburg | South Carolina | 45075 | 112 | 2 |
153500 | 153500 | 2020-05-17 | Orangeburg | South Carolina | 45075 | 112 | 2 |
156517 | 156517 | 2020-05-18 | Orangeburg | South Carolina | 45075 | 113 | 2 |
159538 | 159538 | 2020-05-19 | Orangeburg | South Carolina | 45075 | 115 | 2 |
162565 | 162565 | 2020-05-20 | Orangeburg | South Carolina | 45075 | 117 | 2 |
165594 | 165594 | 2020-05-21 | Orangeburg | South Carolina | 45075 | 119 | 2 |
168630 | 168630 | 2020-05-22 | Orangeburg | South Carolina | 45075 | 122 | 2 |
171669 | 171669 | 2020-05-23 | Orangeburg | South Carolina | 45075 | 135 | 2 |
174711 | 174711 | 2020-05-24 | Orangeburg | South Carolina | 45075 | 139 | 2 |
177755 | 177755 | 2020-05-25 | Orangeburg | South Carolina | 45075 | 143 | 2 |
180798 | 180798 | 2020-05-26 | Orangeburg | South Carolina | 45075 | 152 | 2 |
183848 | 183848 | 2020-05-27 | Orangeburg | South Carolina | 45075 | 160 | 3 |
186905 | 186905 | 2020-05-28 | Orangeburg | South Carolina | 45075 | 161 | 3 |
189967 | 189967 | 2020-05-29 | Orangeburg | South Carolina | 45075 | 168 | 3 |
193032 | 193032 | 2020-05-30 | Orangeburg | South Carolina | 45075 | 179 | 3 |
196101 | 196101 | 2020-05-31 | Orangeburg | South Carolina | 45075 | 189 | 3 |
199174 | 199174 | 2020-06-01 | Orangeburg | South Carolina | 45075 | 201 | 3 |
202249 | 202249 | 2020-06-02 | Orangeburg | South Carolina | 45075 | 210 | 3 |
205326 | 205326 | 2020-06-03 | Orangeburg | South Carolina | 45075 | 213 | 3 |
208407 | 208407 | 2020-06-04 | Orangeburg | South Carolina | 45075 | 227 | 3 |
211489 | 211489 | 2020-06-05 | Orangeburg | South Carolina | 45075 | 242 | 4 |
214575 | 214575 | 2020-06-06 | Orangeburg | South Carolina | 45075 | 250 | 4 |
217665 | 217665 | 2020-06-07 | Orangeburg | South Carolina | 45075 | 255 | 4 |
220757 | 220757 | 2020-06-08 | Orangeburg | South Carolina | 45075 | 273 | 5 |
223852 | 223852 | 2020-06-09 | Orangeburg | South Carolina | 45075 | 283 | 5 |
226952 | 226952 | 2020-06-10 | Orangeburg | South Carolina | 45075 | 287 | 5 |
230056 | 230056 | 2020-06-11 | Orangeburg | South Carolina | 45075 | 301 | 5 |
233161 | 233161 | 2020-06-12 | Orangeburg | South Carolina | 45075 | 309 | 6 |
236266 | 236266 | 2020-06-13 | Orangeburg | South Carolina | 45075 | 330 | 6 |
239374 | 239374 | 2020-06-14 | Orangeburg | South Carolina | 45075 | 359 | 6 |
242483 | 242483 | 2020-06-15 | Orangeburg | South Carolina | 45075 | 394 | 6 |
245595 | 245595 | 2020-06-16 | Orangeburg | South Carolina | 45075 | 415 | 6 |
248708 | 248708 | 2020-06-17 | Orangeburg | South Carolina | 45075 | 417 | 6 |
251823 | 251823 | 2020-06-18 | Orangeburg | South Carolina | 45075 | 430 | 6 |
254938 | 254938 | 2020-06-19 | Orangeburg | South Carolina | 45075 | 457 | 8 |
258064 | 258064 | 2020-06-20 | Orangeburg | South Carolina | 45075 | 471 | 8 |
261191 | 261191 | 2020-06-21 | Orangeburg | South Carolina | 45075 | 506 | 8 |
264319 | 264319 | 2020-06-22 | Orangeburg | South Carolina | 45075 | 524 | 8 |
267447 | 267447 | 2020-06-23 | Orangeburg | South Carolina | 45075 | 539 | 8 |
270581 | 270581 | 2020-06-24 | Orangeburg | South Carolina | 45075 | 567 | 9 |
273720 | 273720 | 2020-06-25 | Orangeburg | South Carolina | 45075 | 594 | 9 |
276867 | 276867 | 2020-06-26 | Orangeburg | South Carolina | 45075 | 621 | 9 |
280015 | 280015 | 2020-06-27 | Orangeburg | South Carolina | 45075 | 643 | 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);