names

34 rows where place_id = 589986

✎ 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
3599481 1867479 1867479 defendant Marten John bytcher 589986 589986 Marten, John, of Bylsyngton, bytcher 0
3639712 1907228 1907228 defendant Dycar Christian laborer 589986 589986 Dycar, Christian, of Bylsyngton, laborer 2
3804176 1959238 1959238 defendant Jenkyn Thomas husbandman 589986 589986 Jenkyn, Thomas, of Bylsyngton, husbandman 3
3861445 1977288 1977288 defendant Duffe Roger laborer 589986 589986 Duffe, Roger, of Bylsyngton, laborer 4
3907877 1992923 1992923 defendant Cowper John husbandman 589986 589986 Cowper, John, of Bylsyngton, husbandman 0
4015418 2030209 2030209 defendant Taylor Thomas yeoman 589986 589986 Taylor, Thomas, of Bylsyngton, yeoman 0
4087547 2055841 2055841 defendant Bullen alias Gyllam Robert joiner 589986 589986 Bullen alias Gyllam, Robert, of Bylsyngton, joiner 0
4566761 2221174 2221174 defendant Shrymplynden Robert   589986 589986 Shrymplynden, Robert, of Bylsyngton 9
4574455 2223541 2223541 defendant (not given) Thomas prior of Brenchesle 589986 589986 Brenchesle, Thomas, of Bylsyngton, prior of the BM 0
4574457 2223542 2223542 defendant (not given) Thomas prior of Brenchesle 589986 589986 Brenchesle, Thomas, of Bylsyngton, prior of the BM 0
4839194 2308187 2308187 defendant Toly John butcher 589986 589986 together with Toly, John, of Bylsyngton, butcher 1
4884737 2322129 2322129 defendant Godewyn Thomas husbandman 589986 589986 Godewyn, Thomas, of Bylsyngton, husbandman 0
4894511 2324956 2324956 defendant Toly Margery widow 589986 589986 Toly, Margery, of Bylsyngton, widow 2
4965465 2346588 2346588 plaintiff Crekynge John, senior   589986 589986 Crekynge, John, senior, of Bylsyngton 0
4979120 2350712 2350712 defendant Crekynge John gent 589986 589986 Crekynge, John, of Bylsyngton, gent 0
4988635 2353558 2353558 plaintiff Brekynge John   589986 589986 Brekynge, John, of Bylsyngton 0
5006301 2358739 2358739 defendant Crekynge John gent 589986 589986 Crekynge, John, of Bylsyngton, gent 0
5025564 2364382 2364382 defendant Crekyng John gent 589986 589986 Crekyng, John, of Bylsyngton, gent 0
5025566 2364383 2364383 defendant Crekyng John gent 589986 589986 Crekyng, John, of Bylsyngton, gent 0
5025919 2364474 2364474 defendant Crekyng John gent 589986 589986 Crekyng, John, of Bylsyngton, gent 0
5027157 2364812 2364812 defendant Godewyn Thomas courser 589986 589986 Godewyn, Thomas, of Bylsyngton, courser 1
5045309 2370223 2370223 defendant Crouche William butcher 589986 589986 Crouche, William, of Bylsyngton, butcher 0
5045434 2370263 2370263 defendant Crekyng John gent 589986 589986 Crekyng, John, of Bylsyngton, gent 0
5087569 2382745 2382745 plaintiff Pote John   589986 589986 Pote, John, of Bylsyngton 2
5198553 2415332 2415332 defendant Godwyn Thomas butcher 589986 589986 Godwyn, Thomas, of Bylsyngton, butcher 3
5210605 2418840 2418840 defendant Godwyn Thomas butcher 589986 589986 Godwyn, Thomas, of Bylsyngton, butcher 3
5335770 2455764 2455764 defendant Goodwyn Edward yeoman 589986 589986 Goodwyn, Edward, of Bylsyngton, yeoman 1
5335771 2455764 2455764 defendant White William husbandman 589986 589986 White, William, of Bylsyngton, husbandman 2
5356086 2461981 2461981 defendant Godewyn Edward yeoman 589986 589986 Godewyn, Edward, of Bylsyngton, yeoman 0
5366404 2465144 2465144 defendant Cowper Hamon husbandman 589986 589986 Cowper, Hamon, of Bylsyngton, husbandman 0
5401387 2475462 2475462 defendant Godewyn Thomas husbandman 589986 589986 Godewyn, Thomas, of Bylsyngton, husbandman 2
5410223 2478010 2478010 defendant Godwyn Thomas husbandman 589986 589986 Godwyn, Thomas, of Bylsyngton, husbandman 0
5412241 2478616 2478616 defendant Godewyn Thomas husbandman 589986 589986 Godewyn, Thomas, of Bylsyngton, husbandman 2
5430190 2483967 2483967 defendant Godewyn Thomas husbandman 589986 589986 Godewyn, Thomas, of Bylsyngton, husbandman 2

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