names

29 rows where place_id = 605996

✎ 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
3663631 1914558 1914558 defendant Davy Thomas husbandman 605996 605996 Davy, Thomas, of Chylton, husbandman 0
3663636 1914559 1914559 defendant Davy Thomas husbandman 605996 605996 Davy, Thomas, of Chylton, husbandman 0
3665347 1915115 1915115 defendant Dene Robert clerk 605996 605996 Dene, Robert, of Chylton, clerk 0
3674286 1918001 1918001 defendant Hardy Thomas husbandman 605996 605996 Hardy, Thomas, of Chylton, husbandman 0
3682075 1920502 1920502 defendant Bayle William husbandman 605996 605996 Bayle, William, of Chylton, husbandman 0
3692098 1923696 1923696 defendant Hawke Richard husbandman 605996 605996 Hawke, Richard, of Chylton, husbandman 0
3697235 1925356 1925356 defendant Bedwyn John husbandman 605996 605996 Bedwyn, John, of Chylton, husbandman 0
3705464 1927999 1927999 defendant May William husbandman 605996 605996 May, William, of Chylton, husbandman 0
3741366 1939168 1939168 defendant Butler Thomas clerk 605996 605996 Butler, Thomas, of Chylton juxta Brygewater, clerk 1
3778780 1951080 1951080 plaintiff Deen Robert clerk 605996 605996 Deen, Robert, of Chylton, clerk 0
3812840 1961916 1961916 defendant Prottes John laborer 605996 605996 Prottes, John, of Chylton, laborer 0
3814343 1962399 1962399 defendant Grene John husbandman 605996 605996 Grene, John, of Chylton, husbandman 1
3833521 1968416 1968416 defendant Brightwell John gent 605996 605996 Brightwell, John, of Chylton, gent 0
3911207 1994074 1994074 defendant Crane Robert esq 605996 605996 Crane, Robert, of Chylton, esq 0
3916498 1995895 1995895 defendant Osborne John husbandman 605996 605996 Osborne, John, of Chylton, husbandman 0
3917042 1996056 1996056 defendant Helyar alias Hegden Thomas husbandman 605996 605996 Helyar alias Hegden, Thomas, of Chylton, husbandman 1
4002218 2025577 2025577 defendant Knopp John husbandman 605996 605996 Knopp, John, of Chylton, husbandman 0
4548978 2215613 2215613 defendant Deye John   605996 605996 Deye, John, of Chylton 0
4548981 2215614 2215614 defendant Deys John   605996 605996 Deys, John, of Chylton 0
4857986 2313865 2313865 defendant Lacy Richard   605996 605996 Lacy, Richard, of Chylton, franklin 1
4911718 2330165 2330165 defendant Tye John   605996 605996 Tye, John, of Chylton, parson 2
5136747 2397268 2397268 defendant Toker Thomas husbandman 605996 605996 Toker, Thomas, of Chylton, husbandman 0
5172865 2407796 2407796 defendant Huchyn John husbandman 605996 605996 Huchyn, John, of Chylton, husbandman 4
5351726 2460640 2460640 defendant Henlet or Heulet Andrew husbandman 605996 605996 Henlet or Heulet, Andrew, of Chylton, husbandman 2
5351727 2460640 2460640 defendant Henlet or Heulet John husbandman 605996 605996 Henlet or Heulet, John, of Chylton, husbandman 3
5351733 2460641 2460641 defendant Henlet or Heulet Andrew husbandman 605996 605996 Henlet or Heulet, Andrew, of Chylton, husbandman 2
5351734 2460641 2460641 defendant Henlet or Heulet John husbandman 605996 605996 Henlet or Heulet, John, of Chylton, husbandman 3
5421221 2481279 2481279 defendant Hommer William gent 605996 605996 Hommer, William, of Chylton, gent 1
5595833 2533608 2533608 defendant Colyns John husbandman 605996 605996 Colyns, John, of Chylton, 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);