names

15 rows where place_id = 660441

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3956537 2009354 2009354 defendant Cotes William husbandman 660441 660441 Cotes, William, of Rylston, husbandman 0
4781905 2290352 2290352 defendant Grymston Robert yeoman 660441 660441 Grymston, Robert, of Rylston, yeoman 2
4820830 2302601 2302601 defendant Fulbarne John gent 660441 660441 Fulbarne, John, of Rylston, gent 1
4972091 2348590 2348590 defendant Wilson Robert yeoman 660441 660441 Wilson, Robert, of Rylston, yeoman 2
5091423 2383879 2383879 defendant Horton William husbandman 660441 660441 Horton, William, of Rylston, husbandman 1
5091424 2383879 2383879 defendant Wylson William husbandman 660441 660441 Wylson, William, of Rylston, husbandman 2
5091425 2383879 2383879 defendant Caly William husbandman 660441 660441 Caly, William, of Rylston, husbandman 3
5091426 2383879 2383879 defendant Blakburn Robert husbandman 660441 660441 Blakburn, Robert, of Rylston, husbandman 4
5091427 2383879 2383879 defendant Wylson Robert husbandman 660441 660441 Wylson, Robert, of Rylston, husbandman 5
5091428 2383879 2383879 defendant Katerynson Henry husbandman 660441 660441 Katerynson, Henry, of Rylston, husbandman 6
5091429 2383879 2383879 defendant Hargraves Robert husbandman 660441 660441 Hargraves, Robert, of Rylston, husbandman 7
5091430 2383879 2383879 defendant Morehous William husbandman 660441 660441 Morehous, William, of Rylston, husbandman 8
5091431 2383879 2383879 defendant Blakburn Henry husbandman 660441 660441 Blakburn, Henry, of Rylston, husbandman 9
5091432 2383879 2383879 defendant Kechyn JOhn husbandman 660441 660441 Kechyn, JOhn, of Rylston, husbandman 10
5091434 2383879 2383879 defendant Rylston William esq 660441 660441 together with Rylston, William, of Rylston, esq 12

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