ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 5009 sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 129 ✖
- 0 96
- 80 91
- 1 55
- 79 30
- 179 20
- 180 20
- 78 19
- 126 19
- 114 13
- 146 13
- 2 12
- 74 12
- 76 12
- 142 12
- 178 12
- 132 11
- 128 10
- 158 9
- 75 8
- 130 8
- 131 8
- 3 7
- 38 7
- 40 7
- 72 7
- 82 7
- 84 7
- 133 7
- 4 6
- 43 6
- 71 6
- 73 6
- 171 6
- 8 5
- 29 5
- 41 5
- 44 5
- 52 5
- 68 5
- 69 5
- 127 5
- 134 5
- 5 4
- 10 4
- 26 4
- 77 4
- 86 4
- 92 4
- 98 4
- 103 4
- 105 4
- 108 4
- 144 4
- 153 4
- 20 3
- 27 3
- 35 3
- 97 3
- 99 3
- 100 3
- 109 3
- 129 3
- 145 3
- 161 3
- 165 3
- 168 3
- 9 2
- 12 2
- 13 2
- 19 2
- 24 2
- 30 2
- 37 2
- 50 2
- 54 2
- 58 2
- 61 2
- 65 2
- 81 2
- 93 2
- 107 2
- 113 2
- 135 2
- 136 2
- 139 2
- 149 2
- 154 2
- 156 2
- 164 2
- 166 2
- 173 2
- 7 1
- 14 1
- 15 1
- 28 1
- 31 1
- 32 1
- 33 1
- 34 1
- 36 1
- 42 1
- 45 1
- 47 1
- 49 1
- 51 1
- 53 1
- 59 1
- 64 1
- 66 1
- 70 1
- 83 1
- 87 1
- 89 1
- 91 1
- 95 1
- 101 1
- 102 1
- 104 1
- 106 1
- 137 1
- 141 1
- 143 1
- 151 1
- 160 1
- 162 1
- 163 1
- 169 1
- 170 1
- 174 1
state 1
- Arkansas 786
fips 1
- 5009 · 786 ✖
county 1
- Boone 786
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
4429 | 4429 | 2020-03-19 | Boone | Arkansas | 5009 | 1 | 0 |
5201 | 5201 | 2020-03-20 | Boone | Arkansas | 5009 | 1 | 0 |
6120 | 6120 | 2020-03-21 | Boone | Arkansas | 5009 | 1 | 0 |
7154 | 7154 | 2020-03-22 | Boone | Arkansas | 5009 | 1 | 0 |
8297 | 8297 | 2020-03-23 | Boone | Arkansas | 5009 | 1 | 0 |
9526 | 9526 | 2020-03-24 | Boone | Arkansas | 5009 | 1 | 0 |
10896 | 10896 | 2020-03-25 | Boone | Arkansas | 5009 | 1 | 0 |
12437 | 12437 | 2020-03-26 | Boone | Arkansas | 5009 | 1 | 0 |
14101 | 14101 | 2020-03-27 | Boone | Arkansas | 5009 | 1 | 0 |
15881 | 15881 | 2020-03-28 | Boone | Arkansas | 5009 | 1 | 0 |
17767 | 17767 | 2020-03-29 | Boone | Arkansas | 5009 | 1 | 0 |
19741 | 19741 | 2020-03-30 | Boone | Arkansas | 5009 | 1 | 0 |
21813 | 21813 | 2020-03-31 | Boone | Arkansas | 5009 | 2 | 0 |
23969 | 23969 | 2020-04-01 | Boone | Arkansas | 5009 | 3 | 0 |
26193 | 26193 | 2020-04-02 | Boone | Arkansas | 5009 | 3 | 0 |
28490 | 28490 | 2020-04-03 | Boone | Arkansas | 5009 | 3 | 0 |
30847 | 30847 | 2020-04-04 | Boone | Arkansas | 5009 | 3 | 0 |
33251 | 33251 | 2020-04-05 | Boone | Arkansas | 5009 | 3 | 0 |
35691 | 35691 | 2020-04-06 | Boone | Arkansas | 5009 | 3 | 0 |
38180 | 38180 | 2020-04-07 | Boone | Arkansas | 5009 | 4 | 0 |
40723 | 40723 | 2020-04-08 | Boone | Arkansas | 5009 | 3 | 0 |
43295 | 43295 | 2020-04-09 | Boone | Arkansas | 5009 | 3 | 0 |
45894 | 45894 | 2020-04-10 | Boone | Arkansas | 5009 | 3 | 0 |
48524 | 48524 | 2020-04-11 | Boone | Arkansas | 5009 | 3 | 0 |
51186 | 51186 | 2020-04-12 | Boone | Arkansas | 5009 | 3 | 0 |
53864 | 53864 | 2020-04-13 | Boone | Arkansas | 5009 | 3 | 0 |
56556 | 56556 | 2020-04-14 | Boone | Arkansas | 5009 | 3 | 0 |
59264 | 59264 | 2020-04-15 | Boone | Arkansas | 5009 | 3 | 0 |
61983 | 61983 | 2020-04-16 | Boone | Arkansas | 5009 | 3 | 0 |
64716 | 64716 | 2020-04-17 | Boone | Arkansas | 5009 | 3 | 0 |
67464 | 67464 | 2020-04-18 | Boone | Arkansas | 5009 | 3 | 0 |
70226 | 70226 | 2020-04-19 | Boone | Arkansas | 5009 | 3 | 0 |
72995 | 72995 | 2020-04-20 | Boone | Arkansas | 5009 | 3 | 0 |
75771 | 75771 | 2020-04-21 | Boone | Arkansas | 5009 | 4 | 0 |
78555 | 78555 | 2020-04-22 | Boone | Arkansas | 5009 | 4 | 0 |
81348 | 81348 | 2020-04-23 | Boone | Arkansas | 5009 | 4 | 0 |
84148 | 84148 | 2020-04-24 | Boone | Arkansas | 5009 | 4 | 0 |
86956 | 86956 | 2020-04-25 | Boone | Arkansas | 5009 | 4 | 0 |
89773 | 89773 | 2020-04-26 | Boone | Arkansas | 5009 | 5 | 0 |
92591 | 92591 | 2020-04-27 | Boone | Arkansas | 5009 | 5 | 0 |
95421 | 95421 | 2020-04-28 | Boone | Arkansas | 5009 | 5 | 0 |
98266 | 98266 | 2020-04-29 | Boone | Arkansas | 5009 | 5 | 0 |
101116 | 101116 | 2020-04-30 | Boone | Arkansas | 5009 | 5 | 0 |
103971 | 103971 | 2020-05-01 | Boone | Arkansas | 5009 | 4 | 0 |
106836 | 106836 | 2020-05-02 | Boone | Arkansas | 5009 | 4 | 0 |
109705 | 109705 | 2020-05-03 | Boone | Arkansas | 5009 | 4 | 0 |
112580 | 112580 | 2020-05-04 | Boone | Arkansas | 5009 | 4 | 0 |
115463 | 115463 | 2020-05-05 | Boone | Arkansas | 5009 | 4 | 0 |
118422 | 118422 | 2020-05-06 | Boone | Arkansas | 5009 | 4 | 0 |
121389 | 121389 | 2020-05-07 | Boone | Arkansas | 5009 | 4 | 0 |
124369 | 124369 | 2020-05-08 | Boone | Arkansas | 5009 | 4 | 0 |
127354 | 127354 | 2020-05-09 | Boone | Arkansas | 5009 | 4 | 0 |
130344 | 130344 | 2020-05-10 | Boone | Arkansas | 5009 | 4 | 0 |
133334 | 133334 | 2020-05-11 | Boone | Arkansas | 5009 | 4 | 0 |
136324 | 136324 | 2020-05-12 | Boone | Arkansas | 5009 | 4 | 0 |
139315 | 139315 | 2020-05-13 | Boone | Arkansas | 5009 | 4 | 0 |
142311 | 142311 | 2020-05-14 | Boone | Arkansas | 5009 | 4 | 0 |
145310 | 145310 | 2020-05-15 | Boone | Arkansas | 5009 | 4 | 0 |
148313 | 148313 | 2020-05-16 | Boone | Arkansas | 5009 | 4 | 0 |
151322 | 151322 | 2020-05-17 | Boone | Arkansas | 5009 | 4 | 0 |
154334 | 154334 | 2020-05-18 | Boone | Arkansas | 5009 | 4 | 0 |
157350 | 157350 | 2020-05-19 | Boone | Arkansas | 5009 | 5 | 0 |
160376 | 160376 | 2020-05-20 | Boone | Arkansas | 5009 | 5 | 0 |
163404 | 163404 | 2020-05-21 | Boone | Arkansas | 5009 | 5 | 0 |
166436 | 166436 | 2020-05-22 | Boone | Arkansas | 5009 | 5 | 0 |
169472 | 169472 | 2020-05-23 | Boone | Arkansas | 5009 | 6 | 0 |
172513 | 172513 | 2020-05-24 | Boone | Arkansas | 5009 | 6 | 0 |
175557 | 175557 | 2020-05-25 | Boone | Arkansas | 5009 | 6 | 0 |
178601 | 178601 | 2020-05-26 | Boone | Arkansas | 5009 | 6 | 0 |
181645 | 181645 | 2020-05-27 | Boone | Arkansas | 5009 | 6 | 0 |
184699 | 184699 | 2020-05-28 | Boone | Arkansas | 5009 | 6 | 0 |
187755 | 187755 | 2020-05-29 | Boone | Arkansas | 5009 | 6 | 0 |
190820 | 190820 | 2020-05-30 | Boone | Arkansas | 5009 | 6 | 0 |
193887 | 193887 | 2020-05-31 | Boone | Arkansas | 5009 | 6 | 0 |
196957 | 196957 | 2020-06-01 | Boone | Arkansas | 5009 | 6 | 0 |
200030 | 200030 | 2020-06-02 | Boone | Arkansas | 5009 | 6 | 0 |
203106 | 203106 | 2020-06-03 | Boone | Arkansas | 5009 | 7 | 0 |
206186 | 206186 | 2020-06-04 | Boone | Arkansas | 5009 | 7 | 0 |
209267 | 209267 | 2020-06-05 | Boone | Arkansas | 5009 | 7 | 0 |
212352 | 212352 | 2020-06-06 | Boone | Arkansas | 5009 | 7 | 0 |
215439 | 215439 | 2020-06-07 | Boone | Arkansas | 5009 | 7 | 0 |
218530 | 218530 | 2020-06-08 | Boone | Arkansas | 5009 | 7 | 0 |
221625 | 221625 | 2020-06-09 | Boone | Arkansas | 5009 | 7 | 0 |
224720 | 224720 | 2020-06-10 | Boone | Arkansas | 5009 | 7 | 0 |
227822 | 227822 | 2020-06-11 | Boone | Arkansas | 5009 | 7 | 0 |
230925 | 230925 | 2020-06-12 | Boone | Arkansas | 5009 | 9 | 0 |
234031 | 234031 | 2020-06-13 | Boone | Arkansas | 5009 | 9 | 0 |
237138 | 237138 | 2020-06-14 | Boone | Arkansas | 5009 | 9 | 0 |
240246 | 240246 | 2020-06-15 | Boone | Arkansas | 5009 | 10 | 0 |
243357 | 243357 | 2020-06-16 | Boone | Arkansas | 5009 | 10 | 0 |
246470 | 246470 | 2020-06-17 | Boone | Arkansas | 5009 | 10 | 0 |
249582 | 249582 | 2020-06-18 | Boone | Arkansas | 5009 | 10 | 0 |
252697 | 252697 | 2020-06-19 | Boone | Arkansas | 5009 | 10 | 0 |
255816 | 255816 | 2020-06-20 | Boone | Arkansas | 5009 | 11 | 0 |
258943 | 258943 | 2020-06-21 | Boone | Arkansas | 5009 | 11 | 0 |
262070 | 262070 | 2020-06-22 | Boone | Arkansas | 5009 | 13 | 0 |
265198 | 265198 | 2020-06-23 | Boone | Arkansas | 5009 | 14 | 1 |
268328 | 268328 | 2020-06-24 | Boone | Arkansas | 5009 | 16 | 1 |
271463 | 271463 | 2020-06-25 | Boone | Arkansas | 5009 | 19 | 1 |
274603 | 274603 | 2020-06-26 | Boone | Arkansas | 5009 | 22 | 1 |
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);