names

17 rows where place_id = 612449

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3693308 1924119 1924119 defendant Hamerton Hugh yeoman 612449 612449 Hamerton, Hugh, of Stokwyth, yeoman 0
3824102 1965410 1965410 defendant Wylbore William husbandman 612449 612449 Wylbore, William, of Stokwyth, husbandman 4
4475618 2193057 2193057 defendant Fouler John   612449 612449 Fouler, John, of Stokwyth, son of Richard 1
4794332 2294370 2294370 plaintiff Poge Thomas   612449 612449 Poge, Thomas, of Stokwyth 0
4838100 2307839 2307839 defendant Cloworth Thomas fisherman 612449 612449 Cloworth, Thomas, of Stokwyth, fisherman 2
4849664 2311372 2311372 defendant Stokwyth James fishmonger 612449 612449 Stokwyth, James, of Stokwyth, fishmonger 3
4852678 2312258 2312258 defendant Barbour John fishmonger 612449 612449 Barbour, John, of Stokwyth, fishmonger 2
4857536 2313744 2313744 defendant Leget John husbandman 612449 612449 Leget, John, of Stokwyth, husbandman 2
4865346 2316131 2316131 defendant Cleworth Thomas fisher 612449 612449 Cleworth, Thomas, of Stokwyth, fisher 2
4872256 2318280 2318280 defendant Clerk Thomas   612449 612449 Clerk, Thomas, of Stokwyth 6
4936128 2337698 2337698 defendant Knyght William cogman 612449 612449 Knyght, William, of Stokwyth, cogman 4
4988102 2353416 2353416 defendant Blakstone Henry fishmonger 612449 612449 Blakstone, Henry, of Stokwyth, fishmonger 0
5061846 2375141 2375141 defendant Hamarton James fisher 612449 612449 Hamarton, James, of Stokwyth, fisher 0
5238420 2426827 2426827 defendant Comforth Robert yeoman 612449 612449 Comforth, Robert, of Stokwyth, yeoman 0
5314142 2449245 2449245 defendant Coumforth alias Compton William fisher or yeoman 612449 612449 Coumforth alias Compton, William, of Stokwyth, fisher or yeoman 0
5329021 2453759 2453759 defendant Hudson William fisher 612449 612449 Hudson, William, of Stokwyth, fisher 3
5581222 2529197 2529197 defendant Hamerton Hugh yeoman 612449 612449 Hamerton, Hugh, of Stokwyth, yeoman 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);