names

44 rows where place_id = 607776

✎ 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
3670746 1916811 1916811 defendant Edward John husbandman 607776 607776 Edward, John, of Goldyngton, husbandman 1
3737717 1938018 1938018 defendant Wakefeld Thomas miller 607776 607776 Wakefeld, Thomas, of Goldyngton, miller 2
3801684 1958422 1958422 defendant Wakefeld Thomas miller 607776 607776 Wakefeld, Thomas, of Goldyngton, miller 0
3858977 1976495 1976495 defendant Daweson Henry miller 607776 607776 Daweson, Henry, of Goldyngton, miller 0
3863914 1978106 1978106 defendant Gale William husbandman 607776 607776 Gale, William, of Goldyngton, husbandman 0
3908467 1993128 1993128 defendant Dawson Henry miller 607776 607776 Dawson, Henry, of Goldyngton, miller 0
4108997 2063474 2063474 defendant Monyngham George yeoman 607776 607776 Monyngham, George, of Goldyngton, yeoman 0
4475029 2192859 2192859 defendant Bailly Thomas   607776 607776 Bailly, Thomas, of Goldyngton 0
4498781 2200252 2200252 defendant Donne John   607776 607776 Donne, John, of Goldyngton, parson 0
4543678 2213918 2213918 defendant atte Ree John   607776 607776 atte Ree, John, of Goldyngton 0
4603362 2232246 2232246 defendant Couper William   607776 607776 Couper, William, of Goldyngton 1
4612184 2234878 2234878 plaintiff Corner John   607776 607776 Corner, John, of Goldyngton 0
4612185 2234878 2234878 defendant Corner Richard   607776 607776 Corner, Richard, of Goldyngton 0
4649220 2245824 2245824 defendant Stoughton Thomas   607776 607776 Stoughton, Thomas, of Goldyngton 3
4652286 2246665 2246665 defendant Boton John   607776 607776 Boton, John, of Goldyngton 1
4667955 2255681 2255681 defendant Andevere John milner 607776 607776 Andevere, John, of Goldyngton, milner 0
4691662 2262926 2262926 defendant Andovere John miller 607776 607776 Andovere, John, of Goldyngton, miller 0
4691663 2262926 2262926 defendant Smyth John husbandman 607776 607776 Smyth, John, of Goldyngton, husbandman 1
4715542 2270191 2270191 defendant Smyth Thomas forester 607776 607776 Smyth, Thomas, of Goldyngton, forester 1
4718424 2271100 2271100 defendant Ussher John miller 607776 607776 Ussher, John, of Goldyngton, miller 1
4744744 2278978 2278978 defendant Andevere John   607776 607776 Andevere, John, of Goldyngton, milward 0
4746256 2279401 2279401 defendant Taillour John husbandman 607776 607776 Taillour, John, of Goldyngton, husbandman 0
4746257 2279401 2279401 defendant Smyth John smith 607776 607776 Smyth, John, of Goldyngton, smith 1
4746258 2279401 2279401 defendant Staliale Richard husbandman 607776 607776 Staliale, Richard, of Goldyngton, husbandman 2
4747737 2279847 2279847 defendant Veisy John husbandman 607776 607776 Veisy, John, of Goldyngton, husbandman 1
4802438 2296954 2296954 defendant Robynson John husbandman 607776 607776 Robynson, John, of Goldyngton, husbandman 4
4839573 2308297 2308297 defendant Hervy Walter carpenter 607776 607776 Hervy, Walter, of Goldyngton, carpenter 0
4866805 2316582 2316582 defendant Taillour John husbandman 607776 607776 Taillour, John, of Goldyngton, husbandman 0
4866806 2316582 2316582 defendant Cole Alan husbandman 607776 607776 Cole, Alan, of Goldyngton, husbandman 1
4866807 2316582 2316582 defendant Staliale Richard husbandman 607776 607776 Staliale, Richard, of Goldyngton, husbandman 2
4880121 2320692 2320692 defendant Cole Alan husbandman 607776 607776 Cole, Alan, of Goldyngton, husbandman 0
4880123 2320693 2320693 defendant Cole Alan husbandman 607776 607776 Cole, Alan, of Goldyngton, husbandman 0
4889838 2323612 2323612 defendant Warner Richard husbandman 607776 607776 Warner, Richard, of Goldyngton, husbandman 2
4892890 2324509 2324509 defendant Hervy Walter carpenter 607776 607776 Hervy, Walter, of Goldyngton, carpenter 0
4894076 2324845 2324845 defendant Warner Richard husbandman 607776 607776 Warner, Richard, of Goldyngton, husbandman 2
4900574 2326820 2326820 defendant Sawage John husbandman 607776 607776 Sawage, John, of Goldyngton, husbandman 5
4924994 2334247 2334247 defendant Cole Alan husbandman 607776 607776 Cole, Alan, of Goldyngton, husbandman 1
4931707 2336303 2336303 defendant Etwell Henry gent 607776 607776 Etwell, Henry, of Goldyngton, gent 0
4969139 2347732 2347732 defendant Hasylden Thomas gent 607776 607776 Hasylden, Thomas, of Goldyngton, gent 0
5011704 2360272 2360272 defendant Clerk Henry husbandman 607776 607776 Clerk, Henry, of Goldyngton, husbandman 2
5017784 2362080 2362080 defendant Boston Richard carpenter 607776 607776 Boston, Richard, of Goldyngton, carpenter 0
5062105 2375222 2375222 plaintiff Haselden Thomas (legal representative) 607776 607776 Haselden, Thomas, of Goldyngton, esq, executor of 0
5151456 2401575 2401575 defendant Cayno John husbandman 607776 607776 Cayno, John, of Goldyngton, husbandman 0
5279067 2438985 2438985 defendant Mate William diker 607776 607776 Mate, William, of Goldyngton, diker 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);