ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
6,144 rows where county = "Mercer" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 8
- New Jersey 778
- West Virginia 775
- Pennsylvania 771
- Ohio 768
- Kentucky 766
- Illinois 759
- North Dakota 727
- Missouri 700
county 1
- Mercer · 6,044 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2462527 | 2462527 | 2022-05-01 | Mercer | North Dakota | 38057 | 2571 | 24 |
2462610 | 2462610 | 2022-05-01 | Mercer | Ohio | 39107 | 9695 | 142 |
2462802 | 2462802 | 2022-05-01 | Mercer | Pennsylvania | 42085 | 23470 | 497 |
2463621 | 2463621 | 2022-05-01 | Mercer | West Virginia | 54055 | 17070 | 265 |
2457899 | 2457899 | 2022-04-30 | Mercer | Illinois | 17131 | 4040 | 47 |
2458319 | 2458319 | 2022-04-30 | Mercer | Kentucky | 21167 | 7360 | 105 |
2458799 | 2458799 | 2022-04-30 | Mercer | Missouri | 29129 | 697 | 13 |
2459039 | 2459039 | 2022-04-30 | Mercer | New Jersey | 34021 | 78785 | 1257 |
2459271 | 2459271 | 2022-04-30 | Mercer | North Dakota | 38057 | 2571 | 24 |
2459354 | 2459354 | 2022-04-30 | Mercer | Ohio | 39107 | 9695 | 142 |
2459546 | 2459546 | 2022-04-30 | Mercer | Pennsylvania | 42085 | 23459 | 497 |
2460365 | 2460365 | 2022-04-30 | Mercer | West Virginia | 54055 | 17070 | 265 |
2454643 | 2454643 | 2022-04-29 | Mercer | Illinois | 17131 | 4040 | 47 |
2455063 | 2455063 | 2022-04-29 | Mercer | Kentucky | 21167 | 7360 | 105 |
2455543 | 2455543 | 2022-04-29 | Mercer | Missouri | 29129 | 697 | 13 |
2455783 | 2455783 | 2022-04-29 | Mercer | New Jersey | 34021 | 78635 | 1257 |
2456015 | 2456015 | 2022-04-29 | Mercer | North Dakota | 38057 | 2571 | 24 |
2456098 | 2456098 | 2022-04-29 | Mercer | Ohio | 39107 | 9695 | 142 |
2456290 | 2456290 | 2022-04-29 | Mercer | Pennsylvania | 42085 | 23449 | 496 |
2457109 | 2457109 | 2022-04-29 | Mercer | West Virginia | 54055 | 17070 | 265 |
2451387 | 2451387 | 2022-04-28 | Mercer | Illinois | 17131 | 4033 | 47 |
2451807 | 2451807 | 2022-04-28 | Mercer | Kentucky | 21167 | 7360 | 105 |
2452287 | 2452287 | 2022-04-28 | Mercer | Missouri | 29129 | 697 | 13 |
2452527 | 2452527 | 2022-04-28 | Mercer | New Jersey | 34021 | 78509 | 1257 |
2452759 | 2452759 | 2022-04-28 | Mercer | North Dakota | 38057 | 2570 | 24 |
2452842 | 2452842 | 2022-04-28 | Mercer | Ohio | 39107 | 9695 | 142 |
2453034 | 2453034 | 2022-04-28 | Mercer | Pennsylvania | 42085 | 23436 | 496 |
2453853 | 2453853 | 2022-04-28 | Mercer | West Virginia | 54055 | 17060 | 265 |
2448131 | 2448131 | 2022-04-27 | Mercer | Illinois | 17131 | 4031 | 47 |
2448551 | 2448551 | 2022-04-27 | Mercer | Kentucky | 21167 | 7360 | 105 |
2449031 | 2449031 | 2022-04-27 | Mercer | Missouri | 29129 | 697 | 13 |
2449271 | 2449271 | 2022-04-27 | Mercer | New Jersey | 34021 | 78380 | 1256 |
2449503 | 2449503 | 2022-04-27 | Mercer | North Dakota | 38057 | 2570 | 24 |
2449586 | 2449586 | 2022-04-27 | Mercer | Ohio | 39107 | 9690 | 142 |
2449778 | 2449778 | 2022-04-27 | Mercer | Pennsylvania | 42085 | 23424 | 496 |
2450597 | 2450597 | 2022-04-27 | Mercer | West Virginia | 54055 | 17051 | 265 |
2444875 | 2444875 | 2022-04-26 | Mercer | Illinois | 17131 | 4027 | 47 |
2445295 | 2445295 | 2022-04-26 | Mercer | Kentucky | 21167 | 7360 | 105 |
2445774 | 2445774 | 2022-04-26 | Mercer | Missouri | 29129 | 697 | 13 |
2446014 | 2446014 | 2022-04-26 | Mercer | New Jersey | 34021 | 78273 | 1256 |
2446246 | 2446246 | 2022-04-26 | Mercer | North Dakota | 38057 | 2570 | 24 |
2446329 | 2446329 | 2022-04-26 | Mercer | Ohio | 39107 | 9690 | 142 |
2446521 | 2446521 | 2022-04-26 | Mercer | Pennsylvania | 42085 | 23407 | 496 |
2447341 | 2447341 | 2022-04-26 | Mercer | West Virginia | 54055 | 17049 | 265 |
2441619 | 2441619 | 2022-04-25 | Mercer | Illinois | 17131 | 4024 | 47 |
2442039 | 2442039 | 2022-04-25 | Mercer | Kentucky | 21167 | 7360 | 105 |
2442519 | 2442519 | 2022-04-25 | Mercer | Missouri | 29129 | 697 | 13 |
2442759 | 2442759 | 2022-04-25 | Mercer | New Jersey | 34021 | 78153 | 1256 |
2442991 | 2442991 | 2022-04-25 | Mercer | North Dakota | 38057 | 2570 | 24 |
2443074 | 2443074 | 2022-04-25 | Mercer | Ohio | 39107 | 9690 | 142 |
2443266 | 2443266 | 2022-04-25 | Mercer | Pennsylvania | 42085 | 23398 | 496 |
2444085 | 2444085 | 2022-04-25 | Mercer | West Virginia | 54055 | 17047 | 265 |
2438363 | 2438363 | 2022-04-24 | Mercer | Illinois | 17131 | 4019 | 47 |
2438783 | 2438783 | 2022-04-24 | Mercer | Kentucky | 21167 | 7350 | 104 |
2439263 | 2439263 | 2022-04-24 | Mercer | Missouri | 29129 | 697 | 13 |
2439503 | 2439503 | 2022-04-24 | Mercer | New Jersey | 34021 | 78090 | 1255 |
2439735 | 2439735 | 2022-04-24 | Mercer | North Dakota | 38057 | 2570 | 24 |
2439818 | 2439818 | 2022-04-24 | Mercer | Ohio | 39107 | 9690 | 142 |
2440010 | 2440010 | 2022-04-24 | Mercer | Pennsylvania | 42085 | 23394 | 496 |
2440829 | 2440829 | 2022-04-24 | Mercer | West Virginia | 54055 | 17038 | 265 |
2435107 | 2435107 | 2022-04-23 | Mercer | Illinois | 17131 | 4019 | 47 |
2435527 | 2435527 | 2022-04-23 | Mercer | Kentucky | 21167 | 7350 | 104 |
2436007 | 2436007 | 2022-04-23 | Mercer | Missouri | 29129 | 697 | 13 |
2436247 | 2436247 | 2022-04-23 | Mercer | New Jersey | 34021 | 78003 | 1255 |
2436479 | 2436479 | 2022-04-23 | Mercer | North Dakota | 38057 | 2570 | 24 |
2436562 | 2436562 | 2022-04-23 | Mercer | Ohio | 39107 | 9690 | 142 |
2436754 | 2436754 | 2022-04-23 | Mercer | Pennsylvania | 42085 | 23391 | 496 |
2437573 | 2437573 | 2022-04-23 | Mercer | West Virginia | 54055 | 17038 | 265 |
2431851 | 2431851 | 2022-04-22 | Mercer | Illinois | 17131 | 4019 | 47 |
2432271 | 2432271 | 2022-04-22 | Mercer | Kentucky | 21167 | 7350 | 104 |
2432751 | 2432751 | 2022-04-22 | Mercer | Missouri | 29129 | 697 | 13 |
2432991 | 2432991 | 2022-04-22 | Mercer | New Jersey | 34021 | 77888 | 1255 |
2433223 | 2433223 | 2022-04-22 | Mercer | North Dakota | 38057 | 2570 | 24 |
2433306 | 2433306 | 2022-04-22 | Mercer | Ohio | 39107 | 9690 | 142 |
2433498 | 2433498 | 2022-04-22 | Mercer | Pennsylvania | 42085 | 23378 | 496 |
2434317 | 2434317 | 2022-04-22 | Mercer | West Virginia | 54055 | 17038 | 265 |
2428595 | 2428595 | 2022-04-21 | Mercer | Illinois | 17131 | 4017 | 47 |
2429015 | 2429015 | 2022-04-21 | Mercer | Kentucky | 21167 | 7350 | 104 |
2429495 | 2429495 | 2022-04-21 | Mercer | Missouri | 29129 | 697 | 13 |
2429735 | 2429735 | 2022-04-21 | Mercer | New Jersey | 34021 | 77759 | 1255 |
2429967 | 2429967 | 2022-04-21 | Mercer | North Dakota | 38057 | 2569 | 24 |
2430050 | 2430050 | 2022-04-21 | Mercer | Ohio | 39107 | 9690 | 142 |
2430242 | 2430242 | 2022-04-21 | Mercer | Pennsylvania | 42085 | 23373 | 496 |
2431061 | 2431061 | 2022-04-21 | Mercer | West Virginia | 54055 | 17033 | 265 |
2425339 | 2425339 | 2022-04-20 | Mercer | Illinois | 17131 | 4014 | 47 |
2425759 | 2425759 | 2022-04-20 | Mercer | Kentucky | 21167 | 7350 | 104 |
2426239 | 2426239 | 2022-04-20 | Mercer | Missouri | 29129 | 697 | 13 |
2426479 | 2426479 | 2022-04-20 | Mercer | New Jersey | 34021 | 77303 | 1255 |
2426711 | 2426711 | 2022-04-20 | Mercer | North Dakota | 38057 | 2569 | 24 |
2426794 | 2426794 | 2022-04-20 | Mercer | Ohio | 39107 | 9685 | 142 |
2426986 | 2426986 | 2022-04-20 | Mercer | Pennsylvania | 42085 | 23368 | 496 |
2427805 | 2427805 | 2022-04-20 | Mercer | West Virginia | 54055 | 17027 | 265 |
2422083 | 2422083 | 2022-04-19 | Mercer | Illinois | 17131 | 4013 | 47 |
2422503 | 2422503 | 2022-04-19 | Mercer | Kentucky | 21167 | 7350 | 104 |
2422983 | 2422983 | 2022-04-19 | Mercer | Missouri | 29129 | 697 | 13 |
2423223 | 2423223 | 2022-04-19 | Mercer | New Jersey | 34021 | 77225 | 1255 |
2423455 | 2423455 | 2022-04-19 | Mercer | North Dakota | 38057 | 2569 | 24 |
2423538 | 2423538 | 2022-04-19 | Mercer | Ohio | 39107 | 9685 | 142 |
2423730 | 2423730 | 2022-04-19 | Mercer | Pennsylvania | 42085 | 23361 | 496 |
2424549 | 2424549 | 2022-04-19 | Mercer | West Virginia | 54055 | 17025 | 265 |
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);