ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,348 rows where county = "Miami" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
deaths 231 ✖
- 0 216
- 2 140
- 42 98
- 1 83
- 69 63
- 25 61
- 159 52
- 73 49
- 93 47
- 30 46
- 66 45
- 41 43
- 64 34
- 74 34
- 5 30
- 59 29
- 43 28
- 70 27
- 72 24
- 7 23
- 31 23
- 158 22
- 4 21
- 61 18
- 68 18
- 76 18
- 87 18
- 226 18
- 228 18
- 65 17
- 15 16
- 44 16
- 483 16
- 67 15
- 49 14
- 56 14
- 214 14
- 473 14
- 482 14
- 22 13
- 48 13
- 51 13
- 86 13
- 101 13
- 3 12
- 27 12
- 58 12
- 90 12
- 45 11
- 82 11
- 222 11
- 237 11
- 19 10
- 47 10
- 80 10
- 221 10
- 343 10
- 14 9
- 75 9
- 40 8
- 78 8
- 103 8
- 117 8
- 122 8
- 9 7
- 39 7
- 46 7
- 62 7
- 109 7
- 148 7
- 206 7
- 215 7
- 217 7
- 223 7
- 225 7
- 229 7
- 235 7
- 348 7
- 352 7
- 453 7
- 476 7
- 480 7
- 37 6
- 91 6
- 92 6
- 94 6
- 105 6
- 119 6
- 126 6
- 472 6
- 38 5
- 53 5
- 55 5
- 57 5
- 79 5
- 83 5
- 85 5
- 139 5
- 144 5
- 10 4
- 17 4
- 28 4
- 32 4
- 36 4
- 54 4
- 60 4
- 107 4
- 137 4
- 152 4
- 156 4
- 177 4
- 189 4
- 194 4
- 199 4
- 203 4
- 205 4
- 211 4
- 220 4
- 232 4
- 242 4
- 249 4
- 261 4
- 271 4
- 284 4
- 296 4
- 306 4
- 322 4
- 329 4
- 340 4
- 355 4
- 360 4
- 369 4
- 375 4
- 379 4
- 389 4
- 408 4
- 422 4
- 435 4
- 446 4
- 463 4
- 469 4
- 8 3
- 18 3
- 21 3
- 23 3
- 33 3
- 34 3
- 35 3
- 77 3
- 98 3
- 116 3
- 131 3
- 135 3
- 136 3
- 146 3
- 149 3
- 175 3
- 198 3
- 200 3
- 204 3
- 210 3
- 212 3
- 224 3
- 227 3
- 231 3
- 233 3
- 238 3
- 244 3
- 253 3
- 265 3
- 275 3
- 289 3
- 299 3
- 313 3
- 326 3
- 332 3
- 357 3
- 363 3
- 371 3
- 377 3
- 381 3
- 395 3
- 410 3
- 429 3
- 436 3
- 461 3
- 465 3
- 470 3
- 6 2
- 12 2
- 24 2
- 71 2
- 81 2
- 84 2
- 95 2
- 106 2
- 114 2
- 121 2
- 125 2
- 127 2
- 145 2
- 153 2
- 179 2
- 190 2
- 11 1
- 13 1
- 20 1
- 26 1
- 29 1
- 52 1
- 89 1
- 97 1
- 100 1
- 104 1
- 110 1
- 112 1
- 123 1
- 128 1
- 129 1
- 132 1
- 133 1
- 140 1
- 142 1
- 151 1
- 154 1
- 157 1
- 172 1
- 173 1
- 178 1
- 184 1
- 187 1
county 1
- Miami · 2,348 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500331 | 2500331 | 2022-05-13 | Miami | Indiana | 18103 | 9292 | 159 |
2500533 | 2500533 | 2022-05-13 | Miami | Kansas | 20121 | 7865 | 93 |
2501698 | 2501698 | 2022-05-13 | Miami | Ohio | 39109 | 25909 | 483 |
2497073 | 2497073 | 2022-05-12 | Miami | Indiana | 18103 | 9285 | 159 |
2497275 | 2497275 | 2022-05-12 | Miami | Kansas | 20121 | 7845 | 93 |
2498440 | 2498440 | 2022-05-12 | Miami | Ohio | 39109 | 25909 | 483 |
2493815 | 2493815 | 2022-05-11 | Miami | Indiana | 18103 | 9285 | 159 |
2494017 | 2494017 | 2022-05-11 | Miami | Kansas | 20121 | 7845 | 93 |
2495182 | 2495182 | 2022-05-11 | Miami | Ohio | 39109 | 25840 | 483 |
2490557 | 2490557 | 2022-05-10 | Miami | Indiana | 18103 | 9285 | 159 |
2490759 | 2490759 | 2022-05-10 | Miami | Kansas | 20121 | 7845 | 93 |
2491924 | 2491924 | 2022-05-10 | Miami | Ohio | 39109 | 25840 | 483 |
2487300 | 2487300 | 2022-05-09 | Miami | Indiana | 18103 | 9285 | 159 |
2487502 | 2487502 | 2022-05-09 | Miami | Kansas | 20121 | 7845 | 93 |
2488666 | 2488666 | 2022-05-09 | Miami | Ohio | 39109 | 25840 | 483 |
2484042 | 2484042 | 2022-05-08 | Miami | Indiana | 18103 | 9280 | 159 |
2484244 | 2484244 | 2022-05-08 | Miami | Kansas | 20121 | 7845 | 93 |
2485409 | 2485409 | 2022-05-08 | Miami | Ohio | 39109 | 25840 | 483 |
2480784 | 2480784 | 2022-05-07 | Miami | Indiana | 18103 | 9280 | 159 |
2480986 | 2480986 | 2022-05-07 | Miami | Kansas | 20121 | 7845 | 93 |
2482151 | 2482151 | 2022-05-07 | Miami | Ohio | 39109 | 25840 | 483 |
2477526 | 2477526 | 2022-05-06 | Miami | Indiana | 18103 | 9280 | 159 |
2477728 | 2477728 | 2022-05-06 | Miami | Kansas | 20121 | 7845 | 93 |
2478893 | 2478893 | 2022-05-06 | Miami | Ohio | 39109 | 25840 | 483 |
2474268 | 2474268 | 2022-05-05 | Miami | Indiana | 18103 | 9280 | 159 |
2474470 | 2474470 | 2022-05-05 | Miami | Kansas | 20121 | 7813 | 93 |
2475635 | 2475635 | 2022-05-05 | Miami | Ohio | 39109 | 25840 | 483 |
2471011 | 2471011 | 2022-05-04 | Miami | Indiana | 18103 | 9280 | 159 |
2471213 | 2471213 | 2022-05-04 | Miami | Kansas | 20121 | 7813 | 93 |
2472378 | 2472378 | 2022-05-04 | Miami | Ohio | 39109 | 25782 | 483 |
2467755 | 2467755 | 2022-05-03 | Miami | Indiana | 18103 | 9276 | 159 |
2467957 | 2467957 | 2022-05-03 | Miami | Kansas | 20121 | 7813 | 93 |
2469122 | 2469122 | 2022-05-03 | Miami | Ohio | 39109 | 25782 | 483 |
2464500 | 2464500 | 2022-05-02 | Miami | Indiana | 18103 | 9276 | 159 |
2464702 | 2464702 | 2022-05-02 | Miami | Kansas | 20121 | 7813 | 93 |
2465866 | 2465866 | 2022-05-02 | Miami | Ohio | 39109 | 25782 | 483 |
2461244 | 2461244 | 2022-05-01 | Miami | Indiana | 18103 | 9270 | 159 |
2461446 | 2461446 | 2022-05-01 | Miami | Kansas | 20121 | 7813 | 93 |
2462611 | 2462611 | 2022-05-01 | Miami | Ohio | 39109 | 25782 | 483 |
2457988 | 2457988 | 2022-04-30 | Miami | Indiana | 18103 | 9270 | 159 |
2458190 | 2458190 | 2022-04-30 | Miami | Kansas | 20121 | 7813 | 93 |
2459355 | 2459355 | 2022-04-30 | Miami | Ohio | 39109 | 25782 | 483 |
2454732 | 2454732 | 2022-04-29 | Miami | Indiana | 18103 | 9270 | 159 |
2454934 | 2454934 | 2022-04-29 | Miami | Kansas | 20121 | 7813 | 93 |
2456099 | 2456099 | 2022-04-29 | Miami | Ohio | 39109 | 25782 | 483 |
2451476 | 2451476 | 2022-04-28 | Miami | Indiana | 18103 | 9268 | 159 |
2451678 | 2451678 | 2022-04-28 | Miami | Kansas | 20121 | 7797 | 93 |
2452843 | 2452843 | 2022-04-28 | Miami | Ohio | 39109 | 25782 | 483 |
2448220 | 2448220 | 2022-04-27 | Miami | Indiana | 18103 | 9268 | 159 |
2448422 | 2448422 | 2022-04-27 | Miami | Kansas | 20121 | 7797 | 93 |
2449587 | 2449587 | 2022-04-27 | Miami | Ohio | 39109 | 25731 | 482 |
2444964 | 2444964 | 2022-04-26 | Miami | Indiana | 18103 | 9263 | 159 |
2445166 | 2445166 | 2022-04-26 | Miami | Kansas | 20121 | 7797 | 93 |
2446330 | 2446330 | 2022-04-26 | Miami | Ohio | 39109 | 25731 | 482 |
2441708 | 2441708 | 2022-04-25 | Miami | Indiana | 18103 | 9263 | 159 |
2441910 | 2441910 | 2022-04-25 | Miami | Kansas | 20121 | 7797 | 93 |
2443075 | 2443075 | 2022-04-25 | Miami | Ohio | 39109 | 25731 | 482 |
2438452 | 2438452 | 2022-04-24 | Miami | Indiana | 18103 | 9261 | 159 |
2438654 | 2438654 | 2022-04-24 | Miami | Kansas | 20121 | 7797 | 93 |
2439819 | 2439819 | 2022-04-24 | Miami | Ohio | 39109 | 25731 | 482 |
2435196 | 2435196 | 2022-04-23 | Miami | Indiana | 18103 | 9261 | 159 |
2435398 | 2435398 | 2022-04-23 | Miami | Kansas | 20121 | 7797 | 93 |
2436563 | 2436563 | 2022-04-23 | Miami | Ohio | 39109 | 25731 | 482 |
2431940 | 2431940 | 2022-04-22 | Miami | Indiana | 18103 | 9261 | 159 |
2432142 | 2432142 | 2022-04-22 | Miami | Kansas | 20121 | 7797 | 93 |
2433307 | 2433307 | 2022-04-22 | Miami | Ohio | 39109 | 25731 | 482 |
2428684 | 2428684 | 2022-04-21 | Miami | Indiana | 18103 | 9259 | 159 |
2428886 | 2428886 | 2022-04-21 | Miami | Kansas | 20121 | 7775 | 93 |
2430051 | 2430051 | 2022-04-21 | Miami | Ohio | 39109 | 25731 | 482 |
2425428 | 2425428 | 2022-04-20 | Miami | Indiana | 18103 | 9259 | 159 |
2425630 | 2425630 | 2022-04-20 | Miami | Kansas | 20121 | 7775 | 93 |
2426795 | 2426795 | 2022-04-20 | Miami | Ohio | 39109 | 25708 | 482 |
2422172 | 2422172 | 2022-04-19 | Miami | Indiana | 18103 | 9258 | 159 |
2422374 | 2422374 | 2022-04-19 | Miami | Kansas | 20121 | 7775 | 93 |
2423539 | 2423539 | 2022-04-19 | Miami | Ohio | 39109 | 25708 | 482 |
2418916 | 2418916 | 2022-04-18 | Miami | Indiana | 18103 | 9258 | 159 |
2419118 | 2419118 | 2022-04-18 | Miami | Kansas | 20121 | 7775 | 93 |
2420282 | 2420282 | 2022-04-18 | Miami | Ohio | 39109 | 25708 | 482 |
2415660 | 2415660 | 2022-04-17 | Miami | Indiana | 18103 | 9255 | 159 |
2415862 | 2415862 | 2022-04-17 | Miami | Kansas | 20121 | 7775 | 93 |
2417027 | 2417027 | 2022-04-17 | Miami | Ohio | 39109 | 25708 | 482 |
2412404 | 2412404 | 2022-04-16 | Miami | Indiana | 18103 | 9255 | 159 |
2412606 | 2412606 | 2022-04-16 | Miami | Kansas | 20121 | 7775 | 93 |
2413771 | 2413771 | 2022-04-16 | Miami | Ohio | 39109 | 25708 | 482 |
2409148 | 2409148 | 2022-04-15 | Miami | Indiana | 18103 | 9255 | 159 |
2409350 | 2409350 | 2022-04-15 | Miami | Kansas | 20121 | 7775 | 93 |
2410515 | 2410515 | 2022-04-15 | Miami | Ohio | 39109 | 25708 | 482 |
2405892 | 2405892 | 2022-04-14 | Miami | Indiana | 18103 | 9255 | 159 |
2406094 | 2406094 | 2022-04-14 | Miami | Kansas | 20121 | 7732 | 93 |
2407259 | 2407259 | 2022-04-14 | Miami | Ohio | 39109 | 25708 | 482 |
2402637 | 2402637 | 2022-04-13 | Miami | Indiana | 18103 | 9255 | 159 |
2402838 | 2402838 | 2022-04-13 | Miami | Kansas | 20121 | 7732 | 93 |
2404003 | 2404003 | 2022-04-13 | Miami | Ohio | 39109 | 25702 | 480 |
2399382 | 2399382 | 2022-04-12 | Miami | Indiana | 18103 | 9254 | 159 |
2399584 | 2399584 | 2022-04-12 | Miami | Kansas | 20121 | 7732 | 93 |
2400748 | 2400748 | 2022-04-12 | Miami | Ohio | 39109 | 25702 | 480 |
2396127 | 2396127 | 2022-04-11 | Miami | Indiana | 18103 | 9254 | 159 |
2396328 | 2396328 | 2022-04-11 | Miami | Kansas | 20121 | 7732 | 93 |
2397493 | 2397493 | 2022-04-11 | Miami | Ohio | 39109 | 25702 | 480 |
2392871 | 2392871 | 2022-04-10 | Miami | Indiana | 18103 | 9253 | 159 |
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);