names

46 rows where place_id = 590073

✎ 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
3599796 1867580 1867580 defendant Baxter Alexander husbandman 590073 590073 Baxter, Alexander, of Fryston, husbandman 1
3745922 1940631 1940631 defendant Marton William clerk 590073 590073 Marton, William, of Fryston, clerk 0
3770135 1948323 1948323 defendant Payne John husbandman 590073 590073 Payne, John, of Fryston, husbandman 0
3809889 1960977 1960977 defendant Leger John laborer 590073 590073 Leger, John, of Fryston, laborer 6
3812453 1961784 1961784 defendant Payne John husbandman 590073 590073 Payne, John, of Fryston, husbandman 0
3812460 1961784 1961784 defendant Leger John laborer 590073 590073 Leger, John, of Fryston, laborer 7
3947531 2006207 2006207 defendant Clyld or Chyld John (legal representative) 590073 590073 Clyld or Chyld, John, of Fryston, husbandman, executors of 0
3963294 2011764 2011764 defendant Foster Alexander clerk 590073 590073 Foster, Alexander, of Fryston, clerk 0
4035835 2037488 2037488 defendant Fletcher Lawrence husbandman 590073 590073 Fletcher, Lawrence, of Fryston, husbandman 3
4035846 2037491 2037491 defendant Fletcher Lawrence husbandman 590073 590073 Fletcher, Lawrence, of Fryston, husbandman 3
4083357 2054331 2054331 defendant Collyngham Simon yeoman 590073 590073 Collyngham, Simon, of Fryston, yeoman 0
4140547 2074861 2074861 defendant Collingham Simon yeoman 590073 590073 Collingham, Simon, of Fryston, yeoman 0
4140549 2074862 2074862 defendant Collyngham Simon yeoman 590073 590073 Collyngham, Simon, of Fryston, yeoman 0
4150097 2078171 2078171 defendant Collyngham Simon yeoman 590073 590073 Collyngham, Simon, of Fryston, yeoman 0
4172324 2085785 2085785 defendant Smyth John smith 590073 590073 Smyth, John, of Fryston, smith 0
4173989 2086359 2086359 defendant Collyngham Simon yeoman 590073 590073 Collyngham, Simon, of Fryston, yeoman 0
4174581 2086580 2086580 defendant Smythe John blacksmith 590073 590073 Smythe, John, of Fryston, blacksmith 1
4184217 2089976 2089976 defendant Fitsharbert Henry husbandman 590073 590073 Fitsharbert, Henry, of Fryston, husbandman 0
4185613 2090475 2090475 defendant Warner William gent 590073 590073 Warner, William, of Fryston, gent 0
4444222 2183175 2183175 defendant Barker Walter   590073 590073 Barker, Walter, of Fryston 0
4450534 2185131 2185131 defendant Barkere Walter   590073 590073 Barkere, Walter, of Fryston 2
4450572 2185140 2185140 defendant Barker Walter   590073 590073 Barker, Walter, of Fryston 1
4604834 2232683 2232683 plaintiff Addewyk John de   590073 590073 Addewyk, John de, of Fryston, vicar 0
4611302 2234600 2234600 plaintiff Clerk Thomas   590073 590073 Clerk, Thomas, of Fryston 0
4628660 2239887 2239887 defendant Forster John   590073 590073 Forster, John, of Fryston 0
4629850 2240260 2240260 defendant Hoton William de   590073 590073 Hoton, William de, of Fryston 1
4685721 2261123 2261123 defendant Pack Thomas husbandman 590073 590073 Pack, Thomas, of Fryston, husbandman 2
4685731 2261126 2261126 defendant Dogeston William husbandman 590073 590073 Dogeston, William, of Fryston, husbandman 1
4765583 2285225 2285225 defendant Watkynson Robert chaplain 590073 590073 Watkynson, Robert, of Fryston, chaplain 0
4797928 2295534 2295534 defendant Raweson Richard husbandman 590073 590073 Raweson, Richard, of Fryston, husbandman 1
4900434 2326780 2326780 defendant Walker Robert walker 590073 590073 Walker, Robert, of Fryston, walker 0
4925908 2334534 2334534 plaintiff Poteman Willam (legal representative) 590073 590073 Poteman, Willam, of Fryston, executors of 0
4951200 2342342 2342342 plaintiff Poteman William (legal representative) 590073 590073 Poteman, William, of Fryston, executors of 0
4962514 2345691 2345691 defendant Herde John husbandman 590073 590073 Herde, John, of Fryston, husbandman 1
5084119 2381754 2381754 defendant Burton William fisher 590073 590073 Burton, William, of Fryston, fisher 0
5097263 2385628 2385628 defendant Swyft Ralph husbandman 590073 590073 Swyft, Ralph, of Fryston, husbandman 1
5100978 2386697 2386697 defendant Kyrkeby Robert chaplain 590073 590073 Kyrkeby, Robert, of Fryston, chaplain 8
5142866 2399042 2399042 defendant Langton Thomas yeoman 590073 590073 Langton, Thomas, of Fryston, yeoman 0
5227245 2423598 2423598 defendant Worme Thomas husbandman 590073 590073 Worme, Thomas, of Fryston, husbandman 5
5324322 2452366 2452366 defendant Pyssh Richard (legal representative) 590073 590073 Pyssh, Richard, of Fryston, merchant, executors of 0
5324325 2452366 2452366 defendant Pyssh John yeoman 590073 590073 Pyssh, John, of Fryston, yeoman 3
5341545 2457546 2457546 defendant Pysshe Richard   590073 590073 Pysshe, Richard, of Fryston, merchant, administrators of 0
5341549 2457546 2457546 defendant Pysshe Thomas merchant 590073 590073 Pysshe, Thomas, of Fryston, merchant 4
5377801 2468641 2468641 defendant Romforth William husbandman 590073 590073 Romforth, William, of Fryston, husbandman 0
5538672 2516577 2516577 defendant Perys James yeoman 590073 590073 Perys, James, of Fryston, yeoman 2
5562576 2523656 2523656 defendant Elmham Robert husbandman 590073 590073 Elmham, Robert, of Fryston, husbandman 4

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);