names

30 rows where place_id = 646995

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3893867 1988171 1988171 defendant Swete Henry clerk 646995 646995 Swete, Henry, of Hotofte, clerk 0
3932476 2001151 2001151 defendant Swete John drover 646995 646995 Swete, John, of Hotofte, drover 0
3958064 2009889 2009889 defendant Goodwyn Thomas yeoman 646995 646995 Goodwyn, Thomas, of Hotofte, yeoman 0
4064485 2047577 2047577 defendant Hochonson Richard husbandman 646995 646995 Hochonson, Richard, of Hotofte, husbandman 0
4726110 2273454 2273454 defendant Frerysse William husbandman 646995 646995 Frerysse, William, of Hotofte, husbandman 0
4841816 2308972 2308972 defendant Tettenay William shipman 646995 646995 Tettenay, William, of Hotofte, shipman 3
5191101 2413136 2413136 defendant Route John husbandman 646995 646995 Route, John, of Hotofte, husbandman 0
5227296 2423612 2423612 defendant Route John husbandman 646995 646995 Route, John, of Hotofte, husbandman 0
5331972 2454637 2454637 plaintiff Carter Robert   646995 646995 Carter, Robert, of Hotofte 0
5354049 2461329 2461329 defendant Pete Alan merchant 646995 646995 Pete, Alan, of Hotofte, merchant 0
5355878 2461914 2461914 defendant Markeby alias Swyne Christopher merchant 646995 646995 Markeby alias Swyne, Christopher, of Hotofte, merchant 0
5384809 2470731 2470731 defendant Wade William butcher 646995 646995 Wade, William, of Hotofte, butcher 0
5384810 2470731 2470731 defendant Blome Thomas husbandman 646995 646995 Blome,Thomas, of Hotofte, husbandman 1
5396834 2474179 2474179 defendant Wade William butcher 646995 646995 Wade, William, of Hotofte, butcher 0
5396835 2474179 2474179 defendant Bloms Thomas husbandman 646995 646995 Bloms, Thomas, of Hotofte, husbandman 1
5434184 2485178 2485178 defendant Coke John weaver 646995 646995 Coke, John, of Hotofte, weaver 5
5434185 2485178 2485178 defendant Drax Alan husbandman 646995 646995 Drax, Alan, of Hotofte, husbandman 6
5434186 2485178 2485178 defendant Purle John laborer 646995 646995 Purle, John, of Hotofte, laborer 7
5434187 2485178 2485178 defendant Webster William shipman 646995 646995 Webster, William, of Hotofte, shipman 8
5434188 2485178 2485178 defendant Bugge John laborer 646995 646995 Bugge, John, of Hotofte, laborer 9
5434189 2485178 2485178 defendant West Thomas laborer 646995 646995 West, Thomas, of Hotofte, laborer 10
5434190 2485178 2485178 defendant West William laborer 646995 646995 West, William, of Hotofte, laborer 11
5442920 2487795 2487795 defendant Wade William butcher 646995 646995 Wade, William, of Hotofte, butcher 0
5442921 2487795 2487795 defendant Blome Thomas husbandman 646995 646995 Blome, Thomas, of Hotofte, husbandman 1
5467465 2495208 2495208 defendant Wade William butcher 646995 646995 Wade, William, of Hotofte, butcher 0
5467466 2495208 2495208 defendant Blome Thomas husbandman 646995 646995 Blome, Thomas, of Hotofte, husbandman 1
5502097 2505577 2505577 defendant Cade William, junior husbandman 646995 646995 Cade, William, junior, of Hotofte, husbandman 0
5518925 2510754 2510754 defendant Laghton Robert yeoman 646995 646995 Laghton, Robert, of Hotofte, yeoman 0
5525330 2512513 2512513 defendant Hogge William yeoman 646995 646995 Hogge, William, of Hotofte, yeoman 2
5532900 2514831 2514831 defendant Wade Robert husbandman 646995 646995 Wade, Robert, of Hotofte, husbandman 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);