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 107
- West Virginia 103
- Pennsylvania 99
- Ohio 96
- Kentucky 95
- Illinois 88
- North Dakota 55
- Missouri 29
county 1
- Mercer · 672 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
281438 | 281438 | 2020-06-28 | Mercer | Illinois | 17131 | 19 | 0 |
281845 | 281845 | 2020-06-28 | Mercer | Kentucky | 21167 | 23 | 0 |
282320 | 282320 | 2020-06-28 | Mercer | Missouri | 29129 | 6 | 0 |
282523 | 282523 | 2020-06-28 | Mercer | New Jersey | 34021 | 7664 | 578 |
282749 | 282749 | 2020-06-28 | Mercer | North Dakota | 38057 | 6 | 0 |
282828 | 282828 | 2020-06-28 | Mercer | Ohio | 39107 | 266 | 8 |
283014 | 283014 | 2020-06-28 | Mercer | Pennsylvania | 42085 | 135 | 6 |
283811 | 283811 | 2020-06-28 | Mercer | West Virginia | 54055 | 36 | 0 |
278290 | 278290 | 2020-06-27 | Mercer | Illinois | 17131 | 20 | 0 |
278697 | 278697 | 2020-06-27 | Mercer | Kentucky | 21167 | 23 | 0 |
279172 | 279172 | 2020-06-27 | Mercer | Missouri | 29129 | 6 | 0 |
279376 | 279376 | 2020-06-27 | Mercer | New Jersey | 34021 | 7657 | 578 |
279603 | 279603 | 2020-06-27 | Mercer | North Dakota | 38057 | 6 | 0 |
279682 | 279682 | 2020-06-27 | Mercer | Ohio | 39107 | 265 | 8 |
279868 | 279868 | 2020-06-27 | Mercer | Pennsylvania | 42085 | 132 | 6 |
280665 | 280665 | 2020-06-27 | Mercer | West Virginia | 54055 | 33 | 0 |
275142 | 275142 | 2020-06-26 | Mercer | Illinois | 17131 | 20 | 0 |
275549 | 275549 | 2020-06-26 | Mercer | Kentucky | 21167 | 23 | 0 |
276024 | 276024 | 2020-06-26 | Mercer | Missouri | 29129 | 6 | 0 |
276228 | 276228 | 2020-06-26 | Mercer | New Jersey | 34021 | 7659 | 577 |
276455 | 276455 | 2020-06-26 | Mercer | North Dakota | 38057 | 6 | 0 |
276534 | 276534 | 2020-06-26 | Mercer | Ohio | 39107 | 265 | 8 |
276720 | 276720 | 2020-06-26 | Mercer | Pennsylvania | 42085 | 130 | 6 |
277517 | 277517 | 2020-06-26 | Mercer | West Virginia | 54055 | 31 | 0 |
272000 | 272000 | 2020-06-25 | Mercer | Illinois | 17131 | 20 | 0 |
272406 | 272406 | 2020-06-25 | Mercer | Kentucky | 21167 | 17 | 0 |
272881 | 272881 | 2020-06-25 | Mercer | Missouri | 29129 | 5 | 0 |
273083 | 273083 | 2020-06-25 | Mercer | New Jersey | 34021 | 7633 | 573 |
273308 | 273308 | 2020-06-25 | Mercer | North Dakota | 38057 | 6 | 0 |
273387 | 273387 | 2020-06-25 | Mercer | Ohio | 39107 | 259 | 8 |
273573 | 273573 | 2020-06-25 | Mercer | Pennsylvania | 42085 | 126 | 6 |
274369 | 274369 | 2020-06-25 | Mercer | West Virginia | 54055 | 30 | 0 |
268863 | 268863 | 2020-06-24 | Mercer | Illinois | 17131 | 20 | 0 |
269270 | 269270 | 2020-06-24 | Mercer | Kentucky | 21167 | 17 | 0 |
269742 | 269742 | 2020-06-24 | Mercer | Missouri | 29129 | 5 | 0 |
269944 | 269944 | 2020-06-24 | Mercer | New Jersey | 34021 | 7572 | 535 |
270169 | 270169 | 2020-06-24 | Mercer | North Dakota | 38057 | 6 | 0 |
270248 | 270248 | 2020-06-24 | Mercer | Ohio | 39107 | 259 | 8 |
270434 | 270434 | 2020-06-24 | Mercer | Pennsylvania | 42085 | 120 | 6 |
271229 | 271229 | 2020-06-24 | Mercer | West Virginia | 54055 | 27 | 0 |
265733 | 265733 | 2020-06-23 | Mercer | Illinois | 17131 | 20 | 0 |
266137 | 266137 | 2020-06-23 | Mercer | Kentucky | 21167 | 17 | 0 |
266609 | 266609 | 2020-06-23 | Mercer | Missouri | 29129 | 5 | 0 |
266809 | 266809 | 2020-06-23 | Mercer | New Jersey | 34021 | 7560 | 530 |
267035 | 267035 | 2020-06-23 | Mercer | North Dakota | 38057 | 6 | 0 |
267114 | 267114 | 2020-06-23 | Mercer | Ohio | 39107 | 258 | 8 |
267300 | 267300 | 2020-06-23 | Mercer | Pennsylvania | 42085 | 119 | 6 |
268095 | 268095 | 2020-06-23 | Mercer | West Virginia | 54055 | 23 | 0 |
262605 | 262605 | 2020-06-22 | Mercer | Illinois | 17131 | 20 | 0 |
263010 | 263010 | 2020-06-22 | Mercer | Kentucky | 21167 | 17 | 0 |
263483 | 263483 | 2020-06-22 | Mercer | Missouri | 29129 | 5 | 0 |
263682 | 263682 | 2020-06-22 | Mercer | New Jersey | 34021 | 7549 | 524 |
263907 | 263907 | 2020-06-22 | Mercer | North Dakota | 38057 | 6 | 0 |
263986 | 263986 | 2020-06-22 | Mercer | Ohio | 39107 | 257 | 8 |
264172 | 264172 | 2020-06-22 | Mercer | Pennsylvania | 42085 | 119 | 6 |
264966 | 264966 | 2020-06-22 | Mercer | West Virginia | 54055 | 22 | 0 |
259478 | 259478 | 2020-06-21 | Mercer | Illinois | 17131 | 20 | 0 |
259881 | 259881 | 2020-06-21 | Mercer | Kentucky | 21167 | 17 | 0 |
260355 | 260355 | 2020-06-21 | Mercer | Missouri | 29129 | 5 | 0 |
260553 | 260553 | 2020-06-21 | Mercer | New Jersey | 34021 | 7541 | 524 |
260779 | 260779 | 2020-06-21 | Mercer | North Dakota | 38057 | 6 | 0 |
260858 | 260858 | 2020-06-21 | Mercer | Ohio | 39107 | 258 | 8 |
261044 | 261044 | 2020-06-21 | Mercer | Pennsylvania | 42085 | 119 | 6 |
261837 | 261837 | 2020-06-21 | Mercer | West Virginia | 54055 | 22 | 0 |
256352 | 256352 | 2020-06-20 | Mercer | Illinois | 17131 | 19 | 0 |
256755 | 256755 | 2020-06-20 | Mercer | Kentucky | 21167 | 17 | 0 |
257229 | 257229 | 2020-06-20 | Mercer | Missouri | 29129 | 5 | 0 |
257427 | 257427 | 2020-06-20 | Mercer | New Jersey | 34021 | 7489 | 524 |
257652 | 257652 | 2020-06-20 | Mercer | North Dakota | 38057 | 6 | 0 |
257731 | 257731 | 2020-06-20 | Mercer | Ohio | 39107 | 257 | 8 |
257917 | 257917 | 2020-06-20 | Mercer | Pennsylvania | 42085 | 118 | 6 |
258710 | 258710 | 2020-06-20 | Mercer | West Virginia | 54055 | 19 | 0 |
253232 | 253232 | 2020-06-19 | Mercer | Illinois | 17131 | 19 | 0 |
253635 | 253635 | 2020-06-19 | Mercer | Kentucky | 21167 | 17 | 0 |
254109 | 254109 | 2020-06-19 | Mercer | Missouri | 29129 | 5 | 0 |
254304 | 254304 | 2020-06-19 | Mercer | New Jersey | 34021 | 7463 | 525 |
254527 | 254527 | 2020-06-19 | Mercer | North Dakota | 38057 | 6 | 0 |
254606 | 254606 | 2020-06-19 | Mercer | Ohio | 39107 | 255 | 8 |
254791 | 254791 | 2020-06-19 | Mercer | Pennsylvania | 42085 | 118 | 6 |
255583 | 255583 | 2020-06-19 | Mercer | West Virginia | 54055 | 16 | 0 |
250117 | 250117 | 2020-06-18 | Mercer | Illinois | 17131 | 19 | 0 |
250520 | 250520 | 2020-06-18 | Mercer | Kentucky | 21167 | 17 | 0 |
250994 | 250994 | 2020-06-18 | Mercer | Missouri | 29129 | 5 | 0 |
251189 | 251189 | 2020-06-18 | Mercer | New Jersey | 34021 | 7416 | 524 |
251412 | 251412 | 2020-06-18 | Mercer | North Dakota | 38057 | 6 | 0 |
251491 | 251491 | 2020-06-18 | Mercer | Ohio | 39107 | 253 | 8 |
251676 | 251676 | 2020-06-18 | Mercer | Pennsylvania | 42085 | 118 | 6 |
252464 | 252464 | 2020-06-18 | Mercer | West Virginia | 54055 | 16 | 0 |
247005 | 247005 | 2020-06-17 | Mercer | Illinois | 17131 | 19 | 0 |
247408 | 247408 | 2020-06-17 | Mercer | Kentucky | 21167 | 16 | 0 |
247881 | 247881 | 2020-06-17 | Mercer | Missouri | 29129 | 5 | 0 |
248074 | 248074 | 2020-06-17 | Mercer | New Jersey | 34021 | 7393 | 523 |
248297 | 248297 | 2020-06-17 | Mercer | North Dakota | 38057 | 6 | 0 |
248376 | 248376 | 2020-06-17 | Mercer | Ohio | 39107 | 253 | 8 |
248561 | 248561 | 2020-06-17 | Mercer | Pennsylvania | 42085 | 117 | 6 |
249349 | 249349 | 2020-06-17 | Mercer | West Virginia | 54055 | 15 | 0 |
243892 | 243892 | 2020-06-16 | Mercer | Illinois | 17131 | 19 | 0 |
244295 | 244295 | 2020-06-16 | Mercer | Kentucky | 21167 | 16 | 0 |
244768 | 244768 | 2020-06-16 | Mercer | Missouri | 29129 | 5 | 0 |
244961 | 244961 | 2020-06-16 | Mercer | New Jersey | 34021 | 7381 | 522 |
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);