names

23 rows where place_id = 589841

✎ 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
3598958 1867303 1867303 plaintiff Synger William   589841 589841 Synger, William, of Drynkston 0
3687253 1922192 1922192 defendant Creme Roger tanner 589841 589841 Creme, Roger, of Drynkston, tanner 0
3699352 1926016 1926016 plaintiff Wren John esq 589841 589841 Wren, John, of Drynkston, esq 0
3699355 1926017 1926017 plaintiff Wren John esq 589841 589841 Wren, John, of Drynkston, esq 0
3743615 1939880 1939880 defendant Skelton Christopher husbandman 589841 589841 Skelton, Christopher, of Drynkston, husbandman 0
3743617 1939880 1939880 defendant Tyler Geoffrey husbandman 589841 589841 Tyler, Geoffrey, of Drynkston, husbandman 2
3799112 1957631 1957631 defendant Seman John husbandman 589841 589841 Seman, John, of Drynkston, husbandman 1
3902104 1990940 1990940 defendant Tyler Thomas yeoman 589841 589841 Tyler, Thomas, of Drynkston, yeoman 0
3918546 1996530 1996530 defendant Turnor James yeoman 589841 589841 Turnor, James, of Drynkston, yeoman 0
4029079 2035044 2035044 defendant Beart Thomas husbandman 589841 589841 Beart, Thomas, of Drynkston, husbandman 0
4307137 2132631 2132631 defendant Sparke William tailor 589841 589841 Sparke, William, of Drynkston, tailor 2
5091982 2384035 2384035 defendant Lynge John gent 589841 589841 Lynge, John, of Drynkston, gent 0
5108464 2388911 2388911 defendant Leynge John gent 589841 589841 Leynge, John, of Drynkston, gent 0
5108467 2388912 2388912 defendant Leynge John gent 589841 589841 Leynge, John, of Drynkston, gent 0
5132633 2396040 2396040 defendant Osteler Adam husbandman 589841 589841 Osteler, Adam, of Drynkston, husbandman 0
5164949 2405484 2405484 defendant Tyse John husbandman 589841 589841 (Tyse, John, of Drynkston, husbandman 2
5178564 2409444 2409444 defendant Tyso John husbandman 589841 589841 (Tyso, John, of Drynkston, husbandman 2
5305660 2446700 2446700 defendant Jerveys Robert husbandman 589841 589841 Jerveys, Robert, of Drynkston, husbandman 0
5305661 2446700 2446700 defendant Seve_ Thomas, sen husbandman 589841 589841 Seve_, Thomas, sen, of Drynkston, husbandman 1
5305662 2446700 2446700 defendant Joly John husbandman 589841 589841 Joly, John, of Drynkston, husbandman 2
5334460 2455380 2455380 defendant Parker Augustine husbandman 589841 589841 Parker, Augustine, of Drynkston, husbandman 1
5519866 2511051 2511051 defendant Barker John husbandman 589841 589841 Barker, John, of Drynkston, husbandman 4
5574243 2527030 2527030 defendant Watton William husbandman 589841 589841 Watton, William, of Drynkston, husbandman 4

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