ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 45075 and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388366 | 388366 | 2020-07-31 | Orangeburg | South Carolina | 45075 | 2120 | 57 |
385149 | 385149 | 2020-07-30 | Orangeburg | South Carolina | 45075 | 2061 | 52 |
381931 | 381931 | 2020-07-29 | Orangeburg | South Carolina | 45075 | 2028 | 50 |
378714 | 378714 | 2020-07-28 | Orangeburg | South Carolina | 45075 | 1992 | 48 |
375498 | 375498 | 2020-07-27 | Orangeburg | South Carolina | 45075 | 1950 | 48 |
372285 | 372285 | 2020-07-26 | Orangeburg | South Carolina | 45075 | 1894 | 48 |
369073 | 369073 | 2020-07-25 | Orangeburg | South Carolina | 45075 | 1851 | 47 |
365864 | 365864 | 2020-07-24 | Orangeburg | South Carolina | 45075 | 1808 | 46 |
362658 | 362658 | 2020-07-23 | Orangeburg | South Carolina | 45075 | 1743 | 42 |
359452 | 359452 | 2020-07-22 | Orangeburg | South Carolina | 45075 | 1697 | 39 |
356248 | 356248 | 2020-07-21 | Orangeburg | South Carolina | 45075 | 1638 | 37 |
353045 | 353045 | 2020-07-20 | Orangeburg | South Carolina | 45075 | 1595 | 36 |
349842 | 349842 | 2020-07-19 | Orangeburg | South Carolina | 45075 | 1565 | 34 |
346642 | 346642 | 2020-07-18 | Orangeburg | South Carolina | 45075 | 1472 | 31 |
343442 | 343442 | 2020-07-17 | Orangeburg | South Carolina | 45075 | 1437 | 30 |
340244 | 340244 | 2020-07-16 | Orangeburg | South Carolina | 45075 | 1383 | 30 |
337047 | 337047 | 2020-07-15 | Orangeburg | South Carolina | 45075 | 1301 | 26 |
333853 | 333853 | 2020-07-14 | Orangeburg | South Carolina | 45075 | 1271 | 26 |
330661 | 330661 | 2020-07-13 | Orangeburg | South Carolina | 45075 | 1226 | 25 |
327475 | 327475 | 2020-07-12 | Orangeburg | South Carolina | 45075 | 1174 | 21 |
324290 | 324290 | 2020-07-11 | Orangeburg | South Carolina | 45075 | 1140 | 21 |
321110 | 321110 | 2020-07-10 | Orangeburg | South Carolina | 45075 | 1066 | 20 |
317932 | 317932 | 2020-07-09 | Orangeburg | South Carolina | 45075 | 1028 | 19 |
314759 | 314759 | 2020-07-08 | Orangeburg | South Carolina | 45075 | 983 | 18 |
311587 | 311587 | 2020-07-07 | Orangeburg | South Carolina | 45075 | 954 | 16 |
308418 | 308418 | 2020-07-06 | Orangeburg | South Carolina | 45075 | 936 | 16 |
305251 | 305251 | 2020-07-05 | Orangeburg | South Carolina | 45075 | 917 | 16 |
302088 | 302088 | 2020-07-04 | Orangeburg | South Carolina | 45075 | 882 | 15 |
298924 | 298924 | 2020-07-03 | Orangeburg | South Carolina | 45075 | 853 | 14 |
295765 | 295765 | 2020-07-02 | Orangeburg | South Carolina | 45075 | 813 | 14 |
292609 | 292609 | 2020-07-01 | Orangeburg | South Carolina | 45075 | 777 | 14 |
289457 | 289457 | 2020-06-30 | Orangeburg | South Carolina | 45075 | 747 | 11 |
286306 | 286306 | 2020-06-29 | Orangeburg | South Carolina | 45075 | 694 | 10 |
283161 | 283161 | 2020-06-28 | Orangeburg | South Carolina | 45075 | 670 | 10 |
280015 | 280015 | 2020-06-27 | Orangeburg | South Carolina | 45075 | 643 | 10 |
276867 | 276867 | 2020-06-26 | Orangeburg | South Carolina | 45075 | 621 | 9 |
273720 | 273720 | 2020-06-25 | Orangeburg | South Carolina | 45075 | 594 | 9 |
270581 | 270581 | 2020-06-24 | Orangeburg | South Carolina | 45075 | 567 | 9 |
267447 | 267447 | 2020-06-23 | Orangeburg | South Carolina | 45075 | 539 | 8 |
264319 | 264319 | 2020-06-22 | Orangeburg | South Carolina | 45075 | 524 | 8 |
261191 | 261191 | 2020-06-21 | Orangeburg | South Carolina | 45075 | 506 | 8 |
258064 | 258064 | 2020-06-20 | Orangeburg | South Carolina | 45075 | 471 | 8 |
254938 | 254938 | 2020-06-19 | Orangeburg | South Carolina | 45075 | 457 | 8 |
251823 | 251823 | 2020-06-18 | Orangeburg | South Carolina | 45075 | 430 | 6 |
248708 | 248708 | 2020-06-17 | Orangeburg | South Carolina | 45075 | 417 | 6 |
245595 | 245595 | 2020-06-16 | Orangeburg | South Carolina | 45075 | 415 | 6 |
242483 | 242483 | 2020-06-15 | Orangeburg | South Carolina | 45075 | 394 | 6 |
239374 | 239374 | 2020-06-14 | Orangeburg | South Carolina | 45075 | 359 | 6 |
236266 | 236266 | 2020-06-13 | Orangeburg | South Carolina | 45075 | 330 | 6 |
233161 | 233161 | 2020-06-12 | Orangeburg | South Carolina | 45075 | 309 | 6 |
230056 | 230056 | 2020-06-11 | Orangeburg | South Carolina | 45075 | 301 | 5 |
226952 | 226952 | 2020-06-10 | Orangeburg | South Carolina | 45075 | 287 | 5 |
223852 | 223852 | 2020-06-09 | Orangeburg | South Carolina | 45075 | 283 | 5 |
220757 | 220757 | 2020-06-08 | Orangeburg | South Carolina | 45075 | 273 | 5 |
217665 | 217665 | 2020-06-07 | Orangeburg | South Carolina | 45075 | 255 | 4 |
214575 | 214575 | 2020-06-06 | Orangeburg | South Carolina | 45075 | 250 | 4 |
211489 | 211489 | 2020-06-05 | Orangeburg | South Carolina | 45075 | 242 | 4 |
208407 | 208407 | 2020-06-04 | Orangeburg | South Carolina | 45075 | 227 | 3 |
205326 | 205326 | 2020-06-03 | Orangeburg | South Carolina | 45075 | 213 | 3 |
202249 | 202249 | 2020-06-02 | Orangeburg | South Carolina | 45075 | 210 | 3 |
199174 | 199174 | 2020-06-01 | Orangeburg | South Carolina | 45075 | 201 | 3 |
196101 | 196101 | 2020-05-31 | Orangeburg | South Carolina | 45075 | 189 | 3 |
193032 | 193032 | 2020-05-30 | Orangeburg | South Carolina | 45075 | 179 | 3 |
189967 | 189967 | 2020-05-29 | Orangeburg | South Carolina | 45075 | 168 | 3 |
186905 | 186905 | 2020-05-28 | Orangeburg | South Carolina | 45075 | 161 | 3 |
183848 | 183848 | 2020-05-27 | Orangeburg | South Carolina | 45075 | 160 | 3 |
180798 | 180798 | 2020-05-26 | Orangeburg | South Carolina | 45075 | 152 | 2 |
177755 | 177755 | 2020-05-25 | Orangeburg | South Carolina | 45075 | 143 | 2 |
174711 | 174711 | 2020-05-24 | Orangeburg | South Carolina | 45075 | 139 | 2 |
171669 | 171669 | 2020-05-23 | Orangeburg | South Carolina | 45075 | 135 | 2 |
168630 | 168630 | 2020-05-22 | Orangeburg | South Carolina | 45075 | 122 | 2 |
165594 | 165594 | 2020-05-21 | Orangeburg | South Carolina | 45075 | 119 | 2 |
162565 | 162565 | 2020-05-20 | Orangeburg | South Carolina | 45075 | 117 | 2 |
159538 | 159538 | 2020-05-19 | Orangeburg | South Carolina | 45075 | 115 | 2 |
156517 | 156517 | 2020-05-18 | Orangeburg | South Carolina | 45075 | 113 | 2 |
153500 | 153500 | 2020-05-17 | Orangeburg | South Carolina | 45075 | 112 | 2 |
150489 | 150489 | 2020-05-16 | Orangeburg | South Carolina | 45075 | 112 | 2 |
147481 | 147481 | 2020-05-15 | Orangeburg | South Carolina | 45075 | 108 | 2 |
144480 | 144480 | 2020-05-14 | Orangeburg | South Carolina | 45075 | 108 | 2 |
141484 | 141484 | 2020-05-13 | Orangeburg | South Carolina | 45075 | 106 | 2 |
138488 | 138488 | 2020-05-12 | Orangeburg | South Carolina | 45075 | 104 | 2 |
135498 | 135498 | 2020-05-11 | Orangeburg | South Carolina | 45075 | 101 | 2 |
132507 | 132507 | 2020-05-10 | Orangeburg | South Carolina | 45075 | 101 | 2 |
129518 | 129518 | 2020-05-09 | Orangeburg | South Carolina | 45075 | 99 | 2 |
126529 | 126529 | 2020-05-08 | Orangeburg | South Carolina | 45075 | 99 | 2 |
123546 | 123546 | 2020-05-07 | Orangeburg | South Carolina | 45075 | 95 | 2 |
120568 | 120568 | 2020-05-06 | Orangeburg | South Carolina | 45075 | 95 | 2 |
117606 | 117606 | 2020-05-05 | Orangeburg | South Carolina | 45075 | 94 | 2 |
114650 | 114650 | 2020-05-04 | Orangeburg | South Carolina | 45075 | 92 | 2 |
111768 | 111768 | 2020-05-03 | Orangeburg | South Carolina | 45075 | 87 | 2 |
108894 | 108894 | 2020-05-02 | Orangeburg | South Carolina | 45075 | 81 | 2 |
106027 | 106027 | 2020-05-01 | Orangeburg | South Carolina | 45075 | 77 | 2 |
103164 | 103164 | 2020-04-30 | Orangeburg | South Carolina | 45075 | 72 | 1 |
100311 | 100311 | 2020-04-29 | Orangeburg | South Carolina | 45075 | 68 | 1 |
97462 | 97462 | 2020-04-28 | Orangeburg | South Carolina | 45075 | 63 | 1 |
94623 | 94623 | 2020-04-27 | Orangeburg | South Carolina | 45075 | 60 | 1 |
91796 | 91796 | 2020-04-26 | Orangeburg | South Carolina | 45075 | 61 | 1 |
88980 | 88980 | 2020-04-25 | Orangeburg | South Carolina | 45075 | 56 | 1 |
86166 | 86166 | 2020-04-24 | Orangeburg | South Carolina | 45075 | 53 | 0 |
83362 | 83362 | 2020-04-23 | Orangeburg | South Carolina | 45075 | 52 | 0 |
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);