us-counties

Table actions

Data source: Big Local News · About: big-local-datasette

570,096 rows sorted by county

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid date county ▼ state fips cases deaths
5001 5001 2020-03-19 Abbeville South Carolina 45001 1 0
5874 5874 2020-03-20 Abbeville South Carolina 45001 1 0
6878 6878 2020-03-21 Abbeville South Carolina 45001 1 0
7998 7998 2020-03-22 Abbeville South Carolina 45001 1 0
9209 9209 2020-03-23 Abbeville South Carolina 45001 1 0
10534 10534 2020-03-24 Abbeville South Carolina 45001 1 0
12005 12005 2020-03-25 Abbeville South Carolina 45001 3 0
13627 13627 2020-03-26 Abbeville South Carolina 45001 4 0
15374 15374 2020-03-27 Abbeville South Carolina 45001 4 0
17228 17228 2020-03-28 Abbeville South Carolina 45001 4 0
19168 19168 2020-03-29 Abbeville South Carolina 45001 4 0
21219 21219 2020-03-30 Abbeville South Carolina 45001 3 0
23356 23356 2020-03-31 Abbeville South Carolina 45001 4 0
25553 25553 2020-04-01 Abbeville South Carolina 45001 4 0
27826 27826 2020-04-02 Abbeville South Carolina 45001 6 0
30161 30161 2020-04-03 Abbeville South Carolina 45001 6 0
32552 32552 2020-04-04 Abbeville South Carolina 45001 6 0
34988 34988 2020-04-05 Abbeville South Carolina 45001 6 0
37463 37463 2020-04-06 Abbeville South Carolina 45001 6 0
39986 39986 2020-04-07 Abbeville South Carolina 45001 5 0
42546 42546 2020-04-08 Abbeville South Carolina 45001 6 0
45132 45132 2020-04-09 Abbeville South Carolina 45001 7 0
47749 47749 2020-04-10 Abbeville South Carolina 45001 7 0
50406 50406 2020-04-11 Abbeville South Carolina 45001 9 0
53079 53079 2020-04-12 Abbeville South Carolina 45001 9 0
55764 55764 2020-04-13 Abbeville South Carolina 45001 9 0
58467 58467 2020-04-14 Abbeville South Carolina 45001 9 0
61182 61182 2020-04-15 Abbeville South Carolina 45001 10 0
63908 63908 2020-04-16 Abbeville South Carolina 45001 10 0
66654 66654 2020-04-17 Abbeville South Carolina 45001 10 0
69412 69412 2020-04-18 Abbeville South Carolina 45001 15 0
72179 72179 2020-04-19 Abbeville South Carolina 45001 17 0
74954 74954 2020-04-20 Abbeville South Carolina 45001 17 0
77736 77736 2020-04-21 Abbeville South Carolina 45001 18 0
80526 80526 2020-04-22 Abbeville South Carolina 45001 22 0
83325 83325 2020-04-23 Abbeville South Carolina 45001 23 0
86129 86129 2020-04-24 Abbeville South Carolina 45001 24 0
88943 88943 2020-04-25 Abbeville South Carolina 45001 24 0
91759 91759 2020-04-26 Abbeville South Carolina 45001 27 0
94586 94586 2020-04-27 Abbeville South Carolina 45001 29 0
97425 97425 2020-04-28 Abbeville South Carolina 45001 29 0
100274 100274 2020-04-29 Abbeville South Carolina 45001 29 0
103127 103127 2020-04-30 Abbeville South Carolina 45001 31 0
105990 105990 2020-05-01 Abbeville South Carolina 45001 31 0
108857 108857 2020-05-02 Abbeville South Carolina 45001 31 0
111731 111731 2020-05-03 Abbeville South Carolina 45001 33 0
114613 114613 2020-05-04 Abbeville South Carolina 45001 33 0
117569 117569 2020-05-05 Abbeville South Carolina 45001 33 0
120531 120531 2020-05-06 Abbeville South Carolina 45001 33 0
123509 123509 2020-05-07 Abbeville South Carolina 45001 34 0
126492 126492 2020-05-08 Abbeville South Carolina 45001 34 0
129481 129481 2020-05-09 Abbeville South Carolina 45001 34 0
132470 132470 2020-05-10 Abbeville South Carolina 45001 34 0
135461 135461 2020-05-11 Abbeville South Carolina 45001 34 0
138451 138451 2020-05-12 Abbeville South Carolina 45001 34 0
141447 141447 2020-05-13 Abbeville South Carolina 45001 34 0
144443 144443 2020-05-14 Abbeville South Carolina 45001 34 0
147444 147444 2020-05-15 Abbeville South Carolina 45001 34 0
150452 150452 2020-05-16 Abbeville South Carolina 45001 34 0
153463 153463 2020-05-17 Abbeville South Carolina 45001 35 0
156480 156480 2020-05-18 Abbeville South Carolina 45001 35 0
159501 159501 2020-05-19 Abbeville South Carolina 45001 36 0
162528 162528 2020-05-20 Abbeville South Carolina 45001 36 0
165557 165557 2020-05-21 Abbeville South Carolina 45001 36 0
168593 168593 2020-05-22 Abbeville South Carolina 45001 36 0
171632 171632 2020-05-23 Abbeville South Carolina 45001 35 0
174674 174674 2020-05-24 Abbeville South Carolina 45001 35 0
177718 177718 2020-05-25 Abbeville South Carolina 45001 35 0
180761 180761 2020-05-26 Abbeville South Carolina 45001 35 0
183811 183811 2020-05-27 Abbeville South Carolina 45001 35 0
186868 186868 2020-05-28 Abbeville South Carolina 45001 37 0
189930 189930 2020-05-29 Abbeville South Carolina 45001 39 0
192995 192995 2020-05-30 Abbeville South Carolina 45001 39 0
196064 196064 2020-05-31 Abbeville South Carolina 45001 42 0
199137 199137 2020-06-01 Abbeville South Carolina 45001 44 0
202212 202212 2020-06-02 Abbeville South Carolina 45001 46 0
205289 205289 2020-06-03 Abbeville South Carolina 45001 46 0
208370 208370 2020-06-04 Abbeville South Carolina 45001 47 0
211453 211453 2020-06-05 Abbeville South Carolina 45001 47 0
214540 214540 2020-06-06 Abbeville South Carolina 45001 49 0
217631 217631 2020-06-07 Abbeville South Carolina 45001 51 0
220724 220724 2020-06-08 Abbeville South Carolina 45001 58 0
223820 223820 2020-06-09 Abbeville South Carolina 45001 60 0
226922 226922 2020-06-10 Abbeville South Carolina 45001 60 0
230027 230027 2020-06-11 Abbeville South Carolina 45001 63 0
233134 233134 2020-06-12 Abbeville South Carolina 45001 62 0
236240 236240 2020-06-13 Abbeville South Carolina 45001 63 0
239349 239349 2020-06-14 Abbeville South Carolina 45001 67 0
242459 242459 2020-06-15 Abbeville South Carolina 45001 70 0
245572 245572 2020-06-16 Abbeville South Carolina 45001 73 0
248686 248686 2020-06-17 Abbeville South Carolina 45001 73 0
251802 251802 2020-06-18 Abbeville South Carolina 45001 73 0
254918 254918 2020-06-19 Abbeville South Carolina 45001 73 0
258045 258045 2020-06-20 Abbeville South Carolina 45001 86 0
261173 261173 2020-06-21 Abbeville South Carolina 45001 88 0
264302 264302 2020-06-22 Abbeville South Carolina 45001 87 0
267432 267432 2020-06-23 Abbeville South Carolina 45001 86 0
270567 270567 2020-06-24 Abbeville South Carolina 45001 91 0
273707 273707 2020-06-25 Abbeville South Carolina 45001 99 0
276855 276855 2020-06-26 Abbeville South Carolina 45001 100 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [us-counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);