ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,559 rows where county = "Berrien" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
deaths 253 ✖
- 0 140
- 72 70
- 41 37
- 46 34
- 12 33
- 60 33
- 70 31
- 47 28
- 82 27
- 83 25
- 30 23
- 1 20
- 302 19
- 40 18
- 74 18
- 35 16
- 53 16
- 57 16
- 61 16
- 27 15
- 42 15
- 44 15
- 71 15
- 45 14
- 81 13
- 11 12
- 29 12
- 69 12
- 43 11
- 76 11
- 290 11
- 306 11
- 31 10
- 48 10
- 50 10
- 78 10
- 80 10
- 10 8
- 28 8
- 54 8
- 59 8
- 63 8
- 66 8
- 67 8
- 68 8
- 75 8
- 245 8
- 3 7
- 13 7
- 49 7
- 222 7
- 294 7
- 297 7
- 303 7
- 305 7
- 312 7
- 548 7
- 549 7
- 550 7
- 551 7
- 555 7
- 557 7
- 2 6
- 14 6
- 25 6
- 51 6
- 52 6
- 250 6
- 259 6
- 286 6
- 289 6
- 300 6
- 329 6
- 8 5
- 64 5
- 65 5
- 106 5
- 205 5
- 224 5
- 242 5
- 247 5
- 248 5
- 270 5
- 278 5
- 288 5
- 293 5
- 308 5
- 315 5
- 322 5
- 330 5
- 331 5
- 333 5
- 341 5
- 345 5
- 385 5
- 396 5
- 418 5
- 432 5
- 447 5
- 481 5
- 498 5
- 521 5
- 529 5
- 539 5
- 543 5
- 6 4
- 15 4
- 24 4
- 55 4
- 73 4
- 77 4
- 86 4
- 189 4
- 212 4
- 235 4
- 282 4
- 287 4
- 509 4
- 7 3
- 20 3
- 22 3
- 33 3
- 37 3
- 79 3
- 93 3
- 102 3
- 115 3
- 127 3
- 177 3
- 178 3
- 193 3
- 227 3
- 234 3
- 251 3
- 252 3
- 255 3
- 265 3
- 299 3
- 304 3
- 307 3
- 328 3
- 336 3
- 351 3
- 359 3
- 372 3
- 464 3
- 513 3
- 535 3
- 561 3
- 4 2
- 5 2
- 9 2
- 18 2
- 26 2
- 32 2
- 36 2
- 39 2
- 56 2
- 89 2
- 91 2
- 103 2
- 113 2
- 132 2
- 149 2
- 162 2
- 166 2
- 209 2
- 217 2
- 225 2
- 228 2
- 236 2
- 238 2
- 239 2
- 249 2
- 253 2
- 264 2
- 267 2
- 268 2
- 271 2
- 273 2
- 275 2
- 283 2
- 311 2
- 320 2
- 324 2
- 332 2
- 335 2
- 337 2
- 342 2
- 347 2
- 349 2
- 352 2
- 354 2
- 360 2
- 365 2
- 374 2
- 389 2
- 405 2
- 415 2
- 428 2
- 444 2
- 463 2
- 468 2
- 478 2
- 494 2
- 517 2
- 528 2
- 534 2
- 536 2
- 538 2
- 542 2
- 21 1
- 34 1
- 38 1
- 58 1
- 94 1
- 97 1
- 99 1
- 100 1
- 108 1
- 114 1
- 116 1
- 117 1
- 121 1
- 123 1
- 135 1
- 142 1
- 150 1
- 154 1
- 156 1
- 169 1
- 174 1
- 203 1
- 204 1
- 210 1
- 211 1
- 213 1
- 232 1
- 233 1
- 237 1
- 246 1
- 254 1
- 256 1
- 258 1
- 260 1
- 261 1
- 274 1
- 276 1
- 277 1
- 281 1
- 284 1
- 291 1
- 292 1
county 1
- Berrien · 1,559 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499975 | 2499975 | 2022-05-13 | Berrien | Georgia | 13019 | 4955 | 83 |
2500831 | 2500831 | 2022-05-13 | Berrien | Michigan | 26021 | 35344 | 561 |
2496717 | 2496717 | 2022-05-12 | Berrien | Georgia | 13019 | 4955 | 83 |
2497573 | 2497573 | 2022-05-12 | Berrien | Michigan | 26021 | 35344 | 561 |
2493459 | 2493459 | 2022-05-11 | Berrien | Georgia | 13019 | 4955 | 83 |
2494315 | 2494315 | 2022-05-11 | Berrien | Michigan | 26021 | 35344 | 561 |
2490201 | 2490201 | 2022-05-10 | Berrien | Georgia | 13019 | 4946 | 83 |
2491057 | 2491057 | 2022-05-10 | Berrien | Michigan | 26021 | 35114 | 557 |
2486944 | 2486944 | 2022-05-09 | Berrien | Georgia | 13019 | 4946 | 83 |
2487800 | 2487800 | 2022-05-09 | Berrien | Michigan | 26021 | 35114 | 557 |
2483686 | 2483686 | 2022-05-08 | Berrien | Georgia | 13019 | 4947 | 83 |
2484542 | 2484542 | 2022-05-08 | Berrien | Michigan | 26021 | 35114 | 557 |
2480428 | 2480428 | 2022-05-07 | Berrien | Georgia | 13019 | 4947 | 83 |
2481284 | 2481284 | 2022-05-07 | Berrien | Michigan | 26021 | 35114 | 557 |
2477170 | 2477170 | 2022-05-06 | Berrien | Georgia | 13019 | 4947 | 83 |
2478026 | 2478026 | 2022-05-06 | Berrien | Michigan | 26021 | 35114 | 557 |
2473912 | 2473912 | 2022-05-05 | Berrien | Georgia | 13019 | 4947 | 83 |
2474768 | 2474768 | 2022-05-05 | Berrien | Michigan | 26021 | 35114 | 557 |
2470655 | 2470655 | 2022-05-04 | Berrien | Georgia | 13019 | 4947 | 83 |
2471511 | 2471511 | 2022-05-04 | Berrien | Michigan | 26021 | 35114 | 557 |
2467399 | 2467399 | 2022-05-03 | Berrien | Georgia | 13019 | 4942 | 83 |
2468255 | 2468255 | 2022-05-03 | Berrien | Michigan | 26021 | 34962 | 555 |
2464144 | 2464144 | 2022-05-02 | Berrien | Georgia | 13019 | 4942 | 83 |
2465000 | 2465000 | 2022-05-02 | Berrien | Michigan | 26021 | 34962 | 555 |
2460888 | 2460888 | 2022-05-01 | Berrien | Georgia | 13019 | 4942 | 83 |
2461744 | 2461744 | 2022-05-01 | Berrien | Michigan | 26021 | 34962 | 555 |
2457632 | 2457632 | 2022-04-30 | Berrien | Georgia | 13019 | 4942 | 83 |
2458488 | 2458488 | 2022-04-30 | Berrien | Michigan | 26021 | 34962 | 555 |
2454376 | 2454376 | 2022-04-29 | Berrien | Georgia | 13019 | 4942 | 83 |
2455232 | 2455232 | 2022-04-29 | Berrien | Michigan | 26021 | 34962 | 555 |
2451120 | 2451120 | 2022-04-28 | Berrien | Georgia | 13019 | 4942 | 83 |
2451976 | 2451976 | 2022-04-28 | Berrien | Michigan | 26021 | 34962 | 555 |
2447864 | 2447864 | 2022-04-27 | Berrien | Georgia | 13019 | 4942 | 83 |
2448720 | 2448720 | 2022-04-27 | Berrien | Michigan | 26021 | 34962 | 555 |
2444608 | 2444608 | 2022-04-26 | Berrien | Georgia | 13019 | 4940 | 83 |
2445464 | 2445464 | 2022-04-26 | Berrien | Michigan | 26021 | 34849 | 551 |
2441352 | 2441352 | 2022-04-25 | Berrien | Georgia | 13019 | 4940 | 83 |
2442208 | 2442208 | 2022-04-25 | Berrien | Michigan | 26021 | 34849 | 551 |
2438096 | 2438096 | 2022-04-24 | Berrien | Georgia | 13019 | 4940 | 83 |
2438952 | 2438952 | 2022-04-24 | Berrien | Michigan | 26021 | 34849 | 551 |
2434840 | 2434840 | 2022-04-23 | Berrien | Georgia | 13019 | 4940 | 83 |
2435696 | 2435696 | 2022-04-23 | Berrien | Michigan | 26021 | 34849 | 551 |
2431584 | 2431584 | 2022-04-22 | Berrien | Georgia | 13019 | 4940 | 83 |
2432440 | 2432440 | 2022-04-22 | Berrien | Michigan | 26021 | 34849 | 551 |
2428328 | 2428328 | 2022-04-21 | Berrien | Georgia | 13019 | 4940 | 83 |
2429184 | 2429184 | 2022-04-21 | Berrien | Michigan | 26021 | 34849 | 551 |
2425072 | 2425072 | 2022-04-20 | Berrien | Georgia | 13019 | 4940 | 83 |
2425928 | 2425928 | 2022-04-20 | Berrien | Michigan | 26021 | 34849 | 551 |
2421816 | 2421816 | 2022-04-19 | Berrien | Georgia | 13019 | 4937 | 82 |
2422672 | 2422672 | 2022-04-19 | Berrien | Michigan | 26021 | 34761 | 550 |
2418560 | 2418560 | 2022-04-18 | Berrien | Georgia | 13019 | 4937 | 82 |
2419416 | 2419416 | 2022-04-18 | Berrien | Michigan | 26021 | 34761 | 550 |
2415304 | 2415304 | 2022-04-17 | Berrien | Georgia | 13019 | 4937 | 82 |
2416160 | 2416160 | 2022-04-17 | Berrien | Michigan | 26021 | 34761 | 550 |
2412048 | 2412048 | 2022-04-16 | Berrien | Georgia | 13019 | 4937 | 82 |
2412904 | 2412904 | 2022-04-16 | Berrien | Michigan | 26021 | 34761 | 550 |
2408792 | 2408792 | 2022-04-15 | Berrien | Georgia | 13019 | 4937 | 82 |
2409648 | 2409648 | 2022-04-15 | Berrien | Michigan | 26021 | 34761 | 550 |
2405536 | 2405536 | 2022-04-14 | Berrien | Georgia | 13019 | 4937 | 82 |
2406392 | 2406392 | 2022-04-14 | Berrien | Michigan | 26021 | 34761 | 550 |
2402281 | 2402281 | 2022-04-13 | Berrien | Georgia | 13019 | 4937 | 82 |
2403136 | 2403136 | 2022-04-13 | Berrien | Michigan | 26021 | 34761 | 550 |
2399026 | 2399026 | 2022-04-12 | Berrien | Georgia | 13019 | 4936 | 82 |
2399882 | 2399882 | 2022-04-12 | Berrien | Michigan | 26021 | 34682 | 549 |
2395771 | 2395771 | 2022-04-11 | Berrien | Georgia | 13019 | 4936 | 82 |
2396626 | 2396626 | 2022-04-11 | Berrien | Michigan | 26021 | 34682 | 549 |
2392515 | 2392515 | 2022-04-10 | Berrien | Georgia | 13019 | 4936 | 82 |
2393371 | 2393371 | 2022-04-10 | Berrien | Michigan | 26021 | 34682 | 549 |
2389259 | 2389259 | 2022-04-09 | Berrien | Georgia | 13019 | 4936 | 82 |
2390115 | 2390115 | 2022-04-09 | Berrien | Michigan | 26021 | 34682 | 549 |
2386004 | 2386004 | 2022-04-08 | Berrien | Georgia | 13019 | 4936 | 82 |
2386859 | 2386859 | 2022-04-08 | Berrien | Michigan | 26021 | 34682 | 549 |
2382749 | 2382749 | 2022-04-07 | Berrien | Georgia | 13019 | 4935 | 82 |
2383604 | 2383604 | 2022-04-07 | Berrien | Michigan | 26021 | 34682 | 549 |
2379494 | 2379494 | 2022-04-06 | Berrien | Georgia | 13019 | 4935 | 82 |
2380349 | 2380349 | 2022-04-06 | Berrien | Michigan | 26021 | 34682 | 549 |
2376240 | 2376240 | 2022-04-05 | Berrien | Georgia | 13019 | 4934 | 82 |
2377094 | 2377094 | 2022-04-05 | Berrien | Michigan | 26021 | 34640 | 548 |
2372988 | 2372988 | 2022-04-04 | Berrien | Georgia | 13019 | 4934 | 82 |
2373842 | 2373842 | 2022-04-04 | Berrien | Michigan | 26021 | 34640 | 548 |
2369735 | 2369735 | 2022-04-03 | Berrien | Georgia | 13019 | 4932 | 82 |
2370589 | 2370589 | 2022-04-03 | Berrien | Michigan | 26021 | 34640 | 548 |
2366482 | 2366482 | 2022-04-02 | Berrien | Georgia | 13019 | 4932 | 82 |
2367336 | 2367336 | 2022-04-02 | Berrien | Michigan | 26021 | 34640 | 548 |
2363229 | 2363229 | 2022-04-01 | Berrien | Georgia | 13019 | 4932 | 82 |
2364083 | 2364083 | 2022-04-01 | Berrien | Michigan | 26021 | 34640 | 548 |
2359975 | 2359975 | 2022-03-31 | Berrien | Georgia | 13019 | 4932 | 82 |
2360829 | 2360829 | 2022-03-31 | Berrien | Michigan | 26021 | 34611 | 548 |
2356721 | 2356721 | 2022-03-30 | Berrien | Georgia | 13019 | 4931 | 82 |
2357575 | 2357575 | 2022-03-30 | Berrien | Michigan | 26021 | 34611 | 548 |
2353468 | 2353468 | 2022-03-29 | Berrien | Georgia | 13019 | 4930 | 82 |
2354322 | 2354322 | 2022-03-29 | Berrien | Michigan | 26021 | 34589 | 543 |
2350216 | 2350216 | 2022-03-28 | Berrien | Georgia | 13019 | 4930 | 82 |
2351070 | 2351070 | 2022-03-28 | Berrien | Michigan | 26021 | 34589 | 543 |
2346963 | 2346963 | 2022-03-27 | Berrien | Georgia | 13019 | 4923 | 82 |
2347817 | 2347817 | 2022-03-27 | Berrien | Michigan | 26021 | 34584 | 543 |
2343710 | 2343710 | 2022-03-26 | Berrien | Georgia | 13019 | 4923 | 82 |
2344564 | 2344564 | 2022-03-26 | Berrien | Michigan | 26021 | 34584 | 543 |
2340457 | 2340457 | 2022-03-25 | Berrien | Georgia | 13019 | 4923 | 82 |
2341311 | 2341311 | 2022-03-25 | Berrien | Michigan | 26021 | 34584 | 543 |
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);