ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
8,543 rows where county = "Crawford" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
deaths 283 ✖
- 0 937
- 1 496
- 5 444
- 17 254
- 14 235
- 19 220
- 40 177
- 3 176
- 2 171
- 6 170
- 41 130
- 28 125
- 21 121
- 15 116
- 8 114
- 30 114
- 35 109
- 47 108
- 22 103
- 4 101
- 16 93
- 42 92
- 43 89
- 83 89
- 130 88
- 46 82
- 23 78
- 54 75
- 10 74
- 7 68
- 37 64
- 20 61
- 111 60
- 36 59
- 61 57
- 53 56
- 45 54
- 101 54
- 49 53
- 119 53
- 12 51
- 24 51
- 38 51
- 120 50
- 29 43
- 31 43
- 112 43
- 34 42
- 52 42
- 9 41
- 13 41
- 51 41
- 113 40
- 32 39
- 117 37
- 214 37
- 100 36
- 110 36
- 26 35
- 39 34
- 48 34
- 55 33
- 157 33
- 82 32
- 11 31
- 25 31
- 27 31
- 115 31
- 122 31
- 44 29
- 50 29
- 18 28
- 60 28
- 80 28
- 94 28
- 102 28
- 104 28
- 156 27
- 96 24
- 57 23
- 149 23
- 33 22
- 56 22
- 74 22
- 107 22
- 318 22
- 179 20
- 147 19
- 58 18
- 128 18
- 165 18
- 76 17
- 172 17
- 247 17
- 249 17
- 89 16
- 136 16
- 144 16
- 207 16
- 212 16
- 97 15
- 162 15
- 175 15
- 190 15
- 78 14
- 91 14
- 98 14
- 116 14
- 143 14
- 153 14
- 248 14
- 314 14
- 73 13
- 95 13
- 59 12
- 125 12
- 114 11
- 138 11
- 150 11
- 168 11
- 180 11
- 311 11
- 87 10
- 141 10
- 158 10
- 209 10
- 64 9
- 85 9
- 135 9
- 151 9
- 154 9
- 159 9
- 171 9
- 193 9
- 201 9
- 66 8
- 90 8
- 93 8
- 126 8
- 127 8
- 139 8
- 146 8
- 192 8
- 197 8
- 245 8
- 315 8
- 77 7
- 84 7
- 106 7
- 124 7
- 169 7
- 178 7
- 186 7
- 187 7
- 203 7
- 205 7
- 218 7
- 225 7
- 92 6
- 99 6
- 123 6
- 133 6
- 160 6
- 246 6
- 62 5
- 72 5
- 75 5
- 103 5
- 129 5
- 140 5
- 145 5
- 148 5
- 164 5
- 173 5
- 181 5
- 244 5
- 253 5
- 264 5
- 270 5
- 309 5
- 68 4
- 109 4
- 118 4
- 131 4
- 132 4
- 134 4
- 152 4
- 166 4
- 167 4
- 184 4
- 191 4
- 200 4
- 234 4
- 272 4
- 295 4
- 310 4
- 317 4
- 63 3
- 69 3
- 70 3
- 121 3
- 163 3
- 174 3
- 177 3
- 185 3
- 188 3
- 189 3
- 204 3
- 213 3
- 217 3
- 219 3
- 221 3
- 231 3
- 235 3
- 236 3
- 238 3
- 260 3
- 278 3
- 290 3
- 298 3
- 300 3
- 305 3
- 320 3
- 65 2
- 67 2
- 79 2
- 86 2
- 88 2
- 105 2
- 108 2
- 155 2
- 170 2
- 182 2
- 183 2
- 196 2
- 199 2
- 202 2
- 215 2
- 224 2
- 226 2
- 230 2
- 239 2
- 241 2
- 261 2
- 265 2
- 277 2
- 289 2
- 299 2
- 304 2
- 71 1
- 137 1
- 176 1
- 194 1
- 208 1
- 211 1
- 216 1
- 222 1
- 223 1
- 227 1
- 228 1
- 229 1
- 232 1
- 242 1
- 243 1
- 252 1
- 256 1
- 258 1
- 259 1
- 262 1
- 267 1
- 268 1
- 271 1
- 274 1
- 275 1
- 283 1
- 285 1
- 292 1
- 293 1
- 296 1
- 303 1
- 307 1
- 308 1
- 313 1
state 11
fips 11
county 1
- Crawford · 8,543 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
9534 | 9534 | 2020-03-24 | Crawford | Arkansas | 5033 | 1 | 0 |
10416 | 10416 | 2020-03-24 | Crawford | Ohio | 39033 | 1 | 0 |
10904 | 10904 | 2020-03-25 | Crawford | Arkansas | 5033 | 1 | 0 |
11318 | 11318 | 2020-03-25 | Crawford | Kansas | 20037 | 1 | 0 |
11863 | 11863 | 2020-03-25 | Crawford | Ohio | 39033 | 1 | 0 |
12446 | 12446 | 2020-03-26 | Crawford | Arkansas | 5033 | 1 | 0 |
12885 | 12885 | 2020-03-26 | Crawford | Kansas | 20037 | 3 | 0 |
13470 | 13470 | 2020-03-26 | Crawford | Ohio | 39033 | 1 | 0 |
13587 | 13587 | 2020-03-26 | Crawford | Pennsylvania | 42039 | 1 | 0 |
14110 | 14110 | 2020-03-27 | Crawford | Arkansas | 5033 | 1 | 0 |
14583 | 14583 | 2020-03-27 | Crawford | Kansas | 20037 | 3 | 0 |
14770 | 14770 | 2020-03-27 | Crawford | Michigan | 26039 | 1 | 0 |
15207 | 15207 | 2020-03-27 | Crawford | Ohio | 39033 | 1 | 0 |
15333 | 15333 | 2020-03-27 | Crawford | Pennsylvania | 42039 | 1 | 0 |
15890 | 15890 | 2020-03-28 | Crawford | Arkansas | 5033 | 1 | 0 |
16268 | 16268 | 2020-03-28 | Crawford | Indiana | 18025 | 1 | 0 |
16390 | 16390 | 2020-03-28 | Crawford | Kansas | 20037 | 3 | 0 |
16590 | 16590 | 2020-03-28 | Crawford | Michigan | 26039 | 1 | 0 |
17049 | 17049 | 2020-03-28 | Crawford | Ohio | 39033 | 2 | 0 |
17182 | 17182 | 2020-03-28 | Crawford | Pennsylvania | 42039 | 2 | 0 |
17776 | 17776 | 2020-03-29 | Crawford | Arkansas | 5033 | 2 | 0 |
18170 | 18170 | 2020-03-29 | Crawford | Indiana | 18025 | 1 | 0 |
18295 | 18295 | 2020-03-29 | Crawford | Kansas | 20037 | 4 | 0 |
18506 | 18506 | 2020-03-29 | Crawford | Michigan | 26039 | 1 | 0 |
18983 | 18983 | 2020-03-29 | Crawford | Ohio | 39033 | 2 | 0 |
19120 | 19120 | 2020-03-29 | Crawford | Pennsylvania | 42039 | 3 | 0 |
19750 | 19750 | 2020-03-30 | Crawford | Arkansas | 5033 | 2 | 0 |
20123 | 20123 | 2020-03-30 | Crawford | Illinois | 17033 | 1 | 0 |
20176 | 20176 | 2020-03-30 | Crawford | Indiana | 18025 | 1 | 0 |
20260 | 20260 | 2020-03-30 | Crawford | Iowa | 19047 | 1 | 0 |
20308 | 20308 | 2020-03-30 | Crawford | Kansas | 20037 | 5 | 1 |
20523 | 20523 | 2020-03-30 | Crawford | Michigan | 26039 | 1 | 0 |
20718 | 20718 | 2020-03-30 | Crawford | Missouri | 29055 | 1 | 0 |
21027 | 21027 | 2020-03-30 | Crawford | Ohio | 39033 | 5 | 0 |
21170 | 21170 | 2020-03-30 | Crawford | Pennsylvania | 42039 | 4 | 0 |
21822 | 21822 | 2020-03-31 | Crawford | Arkansas | 5033 | 3 | 0 |
22214 | 22214 | 2020-03-31 | Crawford | Illinois | 17033 | 1 | 0 |
22270 | 22270 | 2020-03-31 | Crawford | Indiana | 18025 | 1 | 0 |
22356 | 22356 | 2020-03-31 | Crawford | Iowa | 19047 | 1 | 0 |
22406 | 22406 | 2020-03-31 | Crawford | Kansas | 20037 | 5 | 1 |
22634 | 22634 | 2020-03-31 | Crawford | Michigan | 26039 | 1 | 0 |
22836 | 22836 | 2020-03-31 | Crawford | Missouri | 29055 | 1 | 0 |
23159 | 23159 | 2020-03-31 | Crawford | Ohio | 39033 | 5 | 0 |
23306 | 23306 | 2020-03-31 | Crawford | Pennsylvania | 42039 | 4 | 0 |
23979 | 23979 | 2020-04-01 | Crawford | Arkansas | 5033 | 3 | 0 |
24382 | 24382 | 2020-04-01 | Crawford | Illinois | 17033 | 1 | 0 |
24440 | 24440 | 2020-04-01 | Crawford | Indiana | 18025 | 1 | 0 |
24528 | 24528 | 2020-04-01 | Crawford | Iowa | 19047 | 1 | 0 |
24581 | 24581 | 2020-04-01 | Crawford | Kansas | 20037 | 5 | 1 |
24813 | 24813 | 2020-04-01 | Crawford | Michigan | 26039 | 1 | 0 |
25022 | 25022 | 2020-04-01 | Crawford | Missouri | 29055 | 1 | 0 |
25354 | 25354 | 2020-04-01 | Crawford | Ohio | 39033 | 5 | 0 |
25504 | 25504 | 2020-04-01 | Crawford | Pennsylvania | 42039 | 5 | 0 |
26044 | 26044 | 2020-04-01 | Crawford | Wisconsin | 55023 | 1 | 0 |
26203 | 26203 | 2020-04-02 | Crawford | Arkansas | 5033 | 3 | 0 |
26615 | 26615 | 2020-04-02 | Crawford | Illinois | 17033 | 1 | 0 |
26679 | 26679 | 2020-04-02 | Crawford | Indiana | 18025 | 1 | 0 |
26769 | 26769 | 2020-04-02 | Crawford | Iowa | 19047 | 1 | 0 |
26825 | 26825 | 2020-04-02 | Crawford | Kansas | 20037 | 6 | 1 |
27065 | 27065 | 2020-04-02 | Crawford | Michigan | 26039 | 1 | 0 |
27277 | 27277 | 2020-04-02 | Crawford | Missouri | 29055 | 1 | 0 |
27620 | 27620 | 2020-04-02 | Crawford | Ohio | 39033 | 6 | 0 |
27776 | 27776 | 2020-04-02 | Crawford | Pennsylvania | 42039 | 5 | 0 |
28337 | 28337 | 2020-04-02 | Crawford | Wisconsin | 55023 | 1 | 0 |
28500 | 28500 | 2020-04-03 | Crawford | Arkansas | 5033 | 3 | 0 |
28922 | 28922 | 2020-04-03 | Crawford | Illinois | 17033 | 1 | 0 |
28989 | 28989 | 2020-04-03 | Crawford | Indiana | 18025 | 3 | 0 |
29080 | 29080 | 2020-04-03 | Crawford | Iowa | 19047 | 4 | 0 |
29139 | 29139 | 2020-04-03 | Crawford | Kansas | 20037 | 6 | 1 |
29383 | 29383 | 2020-04-03 | Crawford | Michigan | 26039 | 1 | 0 |
29597 | 29597 | 2020-04-03 | Crawford | Missouri | 29055 | 1 | 0 |
29949 | 29949 | 2020-04-03 | Crawford | Ohio | 39033 | 7 | 0 |
30110 | 30110 | 2020-04-03 | Crawford | Pennsylvania | 42039 | 5 | 0 |
30692 | 30692 | 2020-04-03 | Crawford | Wisconsin | 55023 | 1 | 0 |
30857 | 30857 | 2020-04-04 | Crawford | Arkansas | 5033 | 3 | 0 |
31284 | 31284 | 2020-04-04 | Crawford | Illinois | 17033 | 2 | 0 |
31355 | 31355 | 2020-04-04 | Crawford | Indiana | 18025 | 5 | 0 |
31448 | 31448 | 2020-04-04 | Crawford | Iowa | 19047 | 4 | 0 |
31511 | 31511 | 2020-04-04 | Crawford | Kansas | 20037 | 6 | 1 |
31761 | 31761 | 2020-04-04 | Crawford | Michigan | 26039 | 1 | 0 |
31977 | 31977 | 2020-04-04 | Crawford | Missouri | 29055 | 2 | 0 |
32338 | 32338 | 2020-04-04 | Crawford | Ohio | 39033 | 7 | 0 |
32500 | 32500 | 2020-04-04 | Crawford | Pennsylvania | 42039 | 5 | 0 |
33093 | 33093 | 2020-04-04 | Crawford | Wisconsin | 55023 | 1 | 0 |
33261 | 33261 | 2020-04-05 | Crawford | Arkansas | 5033 | 3 | 0 |
33531 | 33531 | 2020-04-05 | Crawford | Georgia | 13079 | 1 | 0 |
33693 | 33693 | 2020-04-05 | Crawford | Illinois | 17033 | 3 | 0 |
33765 | 33765 | 2020-04-05 | Crawford | Indiana | 18025 | 5 | 0 |
33860 | 33860 | 2020-04-05 | Crawford | Iowa | 19047 | 4 | 0 |
33924 | 33924 | 2020-04-05 | Crawford | Kansas | 20037 | 6 | 1 |
34186 | 34186 | 2020-04-05 | Crawford | Michigan | 26039 | 1 | 0 |
34405 | 34405 | 2020-04-05 | Crawford | Missouri | 29055 | 3 | 0 |
34771 | 34771 | 2020-04-05 | Crawford | Ohio | 39033 | 9 | 0 |
34935 | 34935 | 2020-04-05 | Crawford | Pennsylvania | 42039 | 7 | 0 |
35531 | 35531 | 2020-04-05 | Crawford | Wisconsin | 55023 | 2 | 0 |
35702 | 35702 | 2020-04-06 | Crawford | Arkansas | 5033 | 3 | 0 |
35979 | 35979 | 2020-04-06 | Crawford | Georgia | 13079 | 1 | 0 |
36144 | 36144 | 2020-04-06 | Crawford | Illinois | 17033 | 5 | 0 |
36218 | 36218 | 2020-04-06 | Crawford | Indiana | 18025 | 6 | 0 |
36314 | 36314 | 2020-04-06 | Crawford | Iowa | 19047 | 5 | 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);