names

60 rows where place_id = 589696

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3598444 1867142 1867142 plaintiff Sporyt Thomas   589696 589696 Sporyt, Thomas, of Harwod 0
3599709 1867553 1867553 defendant Colton Owen yeoman 589696 589696 Colton, Owen, of Harwod, yeoman 0
3634293 1905522 1905522 defendant Parkynson John laborer 589696 589696 Parkynson, John, of Harwod, laborer 1
3803213 1958909 1958909 plaintiff Quarton William yeoman 589696 589696 Quarton, William, of Harwod, yeoman 0
3805508 1959661 1959661 defendant Redmayn Richard esq 589696 589696 Redmayn, Richard, of Harwod, esq 0
3805510 1959662 1959662 defendant Redmayn Richard esq 589696 589696 Redmayn, Richard, of Harwod, esq 0
4457931 2187500 2187500 defendant Gybson Robert   589696 589696 Gybson, Robert, of Harwod 3
4574839 2223658 2223658 plaintiff Bland Richard   589696 589696 Bland, Richard, of Harwod 0
4623769 2238411 2238411 defendant Dewesbury Robert de butcher 589696 589696 Dewesbury, Robert de, of Harwod, butcher 1
4720482 2271742 2271742 defendant Bost Thomas yeoman 589696 589696 Bost, Thomas, of Harwod, yeoman 1
4720494 2271747 2271747 defendant Redman Richard   589696 589696 Redman, Richard, of Harwod, knight 0
4745085 2279073 2279073 defendant Dutton William yeoman 589696 589696 Dutton, William, of Harwod, yeoman 4
4873386 2318633 2318633 defendant Goodhill John husbandman 589696 589696 Goodhill, John, of Harwod, husbandman 0
4873387 2318633 2318633 defendant Tayte John husbandman 589696 589696 Tayte, John, of Harwod, husbandman 1
4873388 2318633 2318633 defendant Nowete John husbandman 589696 589696 Nowete, John, of Harwod, husbandman 2
4874615 2319006 2319006 defendant Pye John butcher 589696 589696 Pye, John, of Harwod, butcher 0
4874616 2319006 2319006 defendant Brassy William fletcher 589696 589696 Brassy, William, of Harwod, fletcher 1
4874617 2319006 2319006 defendant Studeley Richard tailor 589696 589696 Studeley, Richard, of Harwod, tailor 2
4874618 2319006 2319006 defendant Tayt Robert laborer 589696 589696 Tayt, Robert, of Harwod, laborer 3
4874619 2319006 2319006 defendant Stamforthe William laborer 589696 589696 Stamforthe, William, of Harwod, laborer 4
4874622 2319007 2319007 defendant Wyche John yeoman 589696 589696 Wyche, John, of Harwod, or of Est Keswyke, yeoman 1
4874623 2319007 2319007 defendant Wyche John chaplain 589696 589696 Wyche, John, of Harwod, chaplain 2
4874624 2319007 2319007 defendant Best Thomas yeoman 589696 589696 Best, Thomas, of Harwod, yeoman 3
4887644 2322967 2322967 defendant Best Thomas yeoman 589696 589696 Best, Thomas, of Harwod, yeoman 0
4926671 2334762 2334762 defendant Rudde John laborer 589696 589696 Rudde, John, of Harwod, laborer 0
4929126 2335531 2335531 defendant Dutton William yeoman 589696 589696 Dutton, William, of Harwod,yeoman 0
5001423 2357302 2357302 defendant Tayllour Stephen yeoman 589696 589696 Tayllour, Stephen, of Harwod, yeoman 1
5022897 2363612 2363612 defendant Dutton William yeoman 589696 589696 Dutton, William, of Harwod, yeoman 0
5022898 2363612 2363612 defendant Nawyt John miller 589696 589696 Nawyt, John, of Harwod, miller 1
5034544 2366961 2366961 defendant Dutton William yeoman 589696 589696 (Dutton, William, of Harwod, yeoman 1
5071422 2377946 2377946 defendant Roche John   589696 589696 Roche, John, of Harwod, parish clerk 3
5113099 2390226 2390226 defendant Flesshewer Robert yeoman 589696 589696 Flesshewer, Robert, of Harwod, yeoman 0
5127441 2394501 2394501 defendant Preston John yeoman 589696 589696 Preston, John, of Harwod, yeoman 0
5127442 2394501 2394501 defendant Athyrton John yeoman 589696 589696 Athyrton, John, of Harwod, yeoman 1
5127443 2394501 2394501 defendant Bentley John yeoman 589696 589696 Bentley, John, of Harwod, yeoman 2
5146295 2400047 2400047 defendant Preston John yeoman 589696 589696 Preston, John, of Harwod, yeoman 0
5146296 2400047 2400047 defendant Athurton John yeoman 589696 589696 Athurton, John, of Harwod, yeoman 1
5146297 2400047 2400047 defendant Bentley John yeoman 589696 589696 Bentley, John, of Harwod, yeoman 2
5201031 2416056 2416056 defendant Grene Robert husbandman 589696 589696 Grene, Robert, of Harwod, husbandman 3
5201032 2416056 2416056 defendant Cisson John husbandman 589696 589696 Cisson, John, of Harwod, husbandman 4
5309678 2447933 2447933 defendant Horner David yeoman 589696 589696 Horner, David, of Harwod, yeoman 0
5309679 2447933 2447933 defendant Kay Joan widow 589696 589696 Kay, Joan, of Harwod, widow 1
5309922 2448003 2448003 defendant Aleyn Richard chaplain 589696 589696 Aleyn, Richard, of Harwod, chaplain 3
5327162 2453198 2453198 defendant Aleyn Richard chaplain 589696 589696 together with Aleyn, Richard, of Harwod, chaplain 3
5335233 2455604 2455604 defendant Hudson William smith 589696 589696 Hudson, William, of Harwod, smith 0
5335234 2455604 2455604 defendant Raskyll Richard yeoman 589696 589696 Raskyll, Richard, of Harwod, yeoman 1
5338031 2456461 2456461 defendant Hudson William smith 589696 589696 Hudson, William, of Harwod, smith 0
5342594 2457884 2457884 defendant Tayllour Joan   589696 589696 Tayllour, Joan, of Harwod, widow of Tayllour, Richard 2
5342595 2457884 2457884 defendant Fleshewer Robert yeoman 589696 589696 Fleshewer, Robert, of Harwod, yeoman 3
5377771 2468632 2468632 defendant Preston Roger yeoman 589696 589696 Preston, Roger, of Harwod, yeoman 1
5377772 2468632 2468632 defendant Fletcher John yeoman 589696 589696 Fletcher, John, of Harwod, yeoman 2
5391724 2472704 2472704 defendant Ball John yeoman 589696 589696 Ball, John, of Harwod, yeoman 1
5391725 2472704 2472704 defendant Allyrton Edward yeoman 589696 589696 Allyrton, Edward, of Harwod, yeoman 2
5392576 2472945 2472945 defendant Fleccher John yeoman 589696 589696 Fleccher, John, of Harwod, yeoman 4
5405618 2476681 2476681 defendant Fletcher John yeoman 589696 589696 Fletcher, John, of Harwod, yeoman 4
5405626 2476682 2476682 defendant Fletcher John yeoman 589696 589696 Fletcher, John, of Harwod, yeoman 4
5486345 2500802 2500802 defendant Isotson William husbandman 589696 589696 Isotson, William, of Harwod, husbandman 0
5506716 2507019 2507019 defendant Athyrton John yeoman 589696 589696 Athyrton, John, of Harwod, yeoman 0
5515116 2509575 2509575 defendant Redmayn Edward esq 589696 589696 Redmayn, Edward, of Harwod, esq 0
5606101 2536798 2536798 defendant Ridman Edward (legal representative) 589696 589696 Ridman, Edward, of Harwod, esq, executors of 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);