names

29 rows where place_id = 592257

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3607118 1869892 1869892 defendant Mason John husbandman 592257 592257 Mason, John, of Wytherley, husbandman 0
3680639 1920023 1920023 defendant Kysse Robert husbandman 592257 592257 Kysse, Robert, of Wytherley, husbandman 1
3680640 1920023 1920023 defendant Steme Thomas husbandman 592257 592257 Steme, Thomas, of Wytherley, husbandman 2
3680641 1920023 1920023 defendant Thomas Robert husbandman 592257 592257 Thomas, Robert, of Wytherley, husbandman 3
3680642 1920023 1920023 defendant Johnson William laborer 592257 592257 Johnson, William, of Wytherley, laborer 4
3680643 1920023 1920023 defendant Kene John husbandman 592257 592257 Kene, John, of Wytherley, husbandman 5
3693231 1924093 1924093 defendant Kene John husbandman 592257 592257 Kene, John, of Wytherley, husbandman 0
3906445 1992449 1992449 defendant Steyn Ralph laborer 592257 592257 Steyn, Ralph, of Wytherley, laborer 0
3911954 1994323 1994323 defendant Mason William husbandman 592257 592257 Mason, William, of Wytherley, husbandman 0
3995114 2023000 2023000 defendant Wytherley Richard, junior gent 592257 592257 Wytherley, Richard, junior, of Wytherley, gent 0
4517222 2205786 2205786 defendant Coket Nicholas   592257 592257 Coket, Nicholas, of Wytherley 0
4597006 2230306 2230306 defendant Halle Thomas of the   592257 592257 Halle, Thomas of the, of Wytherley 1
4720735 2271817 2271817 defendant Wytheley Walter husbandman 592257 592257 Wytheley, Walter, of Wytherley, husbandman 0
4814075 2300505 2300505 defendant Fresley John yeoman 592257 592257 Fresley, John, of Wytherley, yeoman 2
4871960 2318210 2318210 defendant Terell Thomas husbandman 592257 592257 Terell, Thomas, of Wytherley, husbandman 1
4871961 2318210 2318210 defendant Lancasshire Thomas husbandman 592257 592257 Lancasshire, Thomas, of Wytherley, husbandman 2
4871962 2318210 2318210 defendant Gamull John husbandman 592257 592257 Gamull, John, of Wytherley, husbandman 3
5217911 2420972 2420972 defendant Barkeby John   592257 592257 Barkeby, John, of Wytherley, servant 0
5237243 2426477 2426477 defendant Preston William husbandman 592257 592257 Preston, William, of Wytherley, husbandman 0
5237245 2426478 2426478 defendant Preston William husbandman 592257 592257 Preston, William, of Wytherley, husbandman 0
5279123 2438998 2438998 defendant Fegyn John weaver 592257 592257 Fegyn, John, of Wytherley, weaver 12
5309538 2447889 2447889 defendant Johnson Thomas husbandman 592257 592257 Johnson, Thomas, of Wytherley, husbandman 0
5326614 2453029 2453029 defendant Grene John yeoman 592257 592257 Grene, John, of Wytherley, yeoman 1
5487235 2501079 2501079 defendant Grene John yeoman 592257 592257 Grene, John, of Wytherley, yeoman 0
5487236 2501079 2501079 defendant Bellesore or Bellefore Richard husbandman 592257 592257 Bellesore or Bellefore, Richard, of Wytherley, husbandman 1
5487237 2501079 2501079 defendant Johnson Thomas husbandman 592257 592257 Johnson, Thomas, of Wytherley, husbandman 2
5523852 2512282 2512282 defendant Hebby Richard husbandman 592257 592257 Hebby, Richard, of Wytherley, husbandman 0
5533525 2515034 2515034 defendant Mason John husbandman 592257 592257 Mason, John, of Wytherley, husbandman 0
5548408 2519569 2519569 defendant Mason John husbandman 592257 592257 Mason, John, of Wytherley, husbandman 1

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