names

34 rows where place_id = 598944

✎ 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
3634627 1905630 1905630 defendant Parbone William grasier 598944 598944 Parbone, William, of Bosworth, Leics, grasier 0
3658824 1913018 1913018 defendant Arsemcole Godrey husbandman 598944 598944 Arsemcole, Godrey, of Bosworth, Leics, husbandman 0
3738219 1938166 1938166 defendant Beamount George gent 598944 598944 Beamount, George, of Bosworth, Leics, gent 0
3738221 1938167 1938167 defendant Beamount George gent 598944 598944 Beamount, George, of Bosworth, Leics, gent 0
3776804 1950487 1950487 defendant Wednall John husbandman 598944 598944 Wednall, John, of Bosworth, Leics, husbandman 1
3831889 1967866 1967866 defendant Assheby John, junior gent 598944 598944 Assheby, John, junior, of Bosworth, Leics, gent 2
4001528 2025327 2025327 defendant Burton Thomas yeoman 598944 598944 Burton, Thomas, of Bosworth, Leics, yeoman 1
4014693 2029971 2029971 defendant Burton Thomas yeoman 598944 598944 Burton, Thomas, of Bosworth, Leics, yeoman 0
4022620 2032812 2032812 plaintiff Ashby Georgem yeoman 598944 598944 Ashby, Georgem, of Bosworth, Leics, yeoman 0
4063460 2047221 2047221 defendant Warde Randolph husbandman 598944 598944 Warde, Randolph, of Bosworth, Leics, husbandman 0
4525012 2208164 2208164 plaintiff Hurleman Ralph   598944 598944 Hurleman, Ralph, of Bosworth, Leics 0
4525014 2208165 2208165 plaintiff Hurleman Ralph   598944 598944 Hurleman, Ralph, of Bosworth, Leics 0
4667366 2255516 2255516 defendant Inse John gent 598944 598944 Inse, John, of Bosworth, Leics, gent 3
4801991 2296809 2296809 plaintiff Yns John   598944 598944 Yns, John, of Bosworth, Leics 0
4844167 2309683 2309683 defendant Gerard John husbandman 598944 598944 Gerard, John, of Bosworth, Leics, husbandman 3
5120401 2392393 2392393 defendant Assheby John yeoman 598944 598944 Assheby, John, of Bosworth, Leics, yeoman 2
5164424 2405329 2405329 defendant Haywod Thomas   598944 598944 Haywod, Thomas, of Bosworth, Leics, parson 0
5177650 2409159 2409159 defendant Haywod Thomas   598944 598944 Haywod, Thomas, of Bosworth, Leics, parson 0
5230090 2424418 2424418 defendant Adcok John chapman 598944 598944 Adcok, John, of Bosworth, Leics, chapman 3
5230101 2424420 2424420 defendant Adcok John chapman 598944 598944 Adcok, John, of Bosworth, Leics, chapman 3
5241084 2427592 2427592 defendant Adcok John chapman 598944 598944 Adcok, John, of Bosworth, Leics, chapman 1
5241088 2427593 2427593 defendant Adcok John chapman 598944 598944 Adcok, John, of Bosworth, Leics, chapman 1
5248593 2429710 2429710 defendant Freman John baker 598944 598944 Freman, John, of Bosworth, Leics, baker 0
5248595 2429711 2429711 defendant Freman John baker 598944 598944 Freman, John, of Bosworth, Leics, baker 0
5297934 2444406 2444406 defendant Dethek Philip gent 598944 598944 Dethek, Philip, of Bosworth, Leics, gent 0
5307514 2447260 2447260 defendant Dethek Philip gent 598944 598944 Dethek, Philip, of Bosworth, Leics, gent 0
5307517 2447261 2447261 defendant Dethek Philip gent 598944 598944 Dethek, Philip, of Bosworth, Leics, gent 0
5345650 2458799 2458799 defendant Adcok John chapman 598944 598944 Adcok, John, of Bosworth, Leics, chapman 2
5345682 2458803 2458803 defendant Adcok John chapman 598944 598944 together with Adcok, John, of Bosworth, Leics, chapman 1
5371367 2466624 2466624 defendant Hardcourt William gent 598944 598944 Hardcourt, William, of Bosworth, Leics, gent 0
5401739 2475556 2475556 plaintiff Heywod Thomas   598944 598944 Heywod, Thomas, of Bosworth, Leics, parson 0
5401744 2475557 2475557 defendant Hardcourt William gent 598944 598944 Hardcourt, William, of Bosworth, Leics, gent 0
5459686 2492815 2492815 defendant Harecourt William gent 598944 598944 Harecourt, William, of Bosworth, Leics, gent 0
5482682 2499765 2499765 defendant Harecourt William gent 598944 598944 Harecourt, William, of Bosworth, Leics, gent 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);