names

29 rows where place_id = 588588

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3595002 1866067 1866067 defendant Kyng William miller 588588 588588 Kyng, William, of Bykelyswade, miller 0
3595014 1866072 1866072 defendant Colmorth Thomas gent 588588 588588 Colmorth, Thomas, of Bykelyswade, gent 2
3612541 1871556 1871556 defendant Bulle John laborer 588588 588588 Bulle, John, of Bykelyswade, laborer 1
3612542 1871556 1871556 defendant Asper Lucy widow 588588 588588 Asper, Lucy, of Bykelyswade, widow 2
3612543 1871556 1871556 defendant Asper Joyce spinster 588588 588588 Asper, Joyce, of Bykelyswade, spinster 3
3674035 1917919 1917919 defendant Wyllymot John yeoman 588588 588588 Wyllymot, John, of Bykelyswade, yeoman 2
3683631 1921011 1921011 defendant Taylar William husbandman 588588 588588 Taylar, William, of Bykelyswade, husbandman 0
3711659 1929959 1929959 defendant Coke Richard yeoman 588588 588588 Coke, Richard, of Bykelyswade, yeoman 0
3711661 1929959 1929959 defendant Graunte William laborer 588588 588588 Graunte, William, of Bykelyswade, laborer 2
3816212 1962979 1962979 defendant Wyllymot Henry husbandman 588588 588588 Wyllymot, Henry, of Bykelyswade, husbandman 0
4734243 2275886 2275886 defendant Stratton Thomas gent 588588 588588 Stratton, Thomas, of Bykelyswade, gent 0
4734244 2275886 2275886 defendant Buntyng John yeoman 588588 588588 Buntyng, John, of Bykelyswade, yeoman 1
4752983 2281324 2281324 defendant Maynepeny John yeoman 588588 588588 Maynepeny, John, of Bykelyswade, yeoman 0
4979075 2350698 2350698 defendant Sybbesson John fisher 588588 588588 Sybbesson, John, of Bykelyswade, fisher 1
4981250 2351316 2351316 defendant Orvey William husbandman 588588 588588 Orvey, William, of Bykelyswade, husbandman 0
4981251 2351316 2351316 defendant Petypas George husbandman 588588 588588 Petypas, George, of Bykelyswade, husbandman 1
4981651 2351428 2351428 plaintiff Sybsone John fisher 588588 588588 Sybsone, John, of Bykelyswade, fisher 0
4981652 2351428 2351428 defendant May William painter 588588 588588 May, William, of Bykelyswade, painter 0
5220051 2421574 2421574 plaintiff Horle Thomas   588588 588588 Horle, Thomas, of Bykelyswade 0
5231101 2424694 2424694 defendant Kebyll Robert husbandman 588588 588588 Kebyll, Robert, of Bykelyswade, husbandman 0
5349259 2459897 2459897 defendant Langeforde Richard husbandman 588588 588588 Langeforde, Richard, of Bykelyswade, husbandman 0
5349260 2459897 2459897 defendant Langeforde Margaret widow 588588 588588 Langeforde, Margaret, of Bykelyswade, widow 1
5350247 2460198 2460198 defendant Halle Ellen (legal representative) 588588 588588 Halle, Ellen, of Bykelyswade, widow, executor of 0
5350248 2460198 2460198 defendant Bray William husbandman 588588 588588 Bray, William, of Bykelyswade, husbandman 1
5363452 2464220 2464220 defendant Kebull Robert fisher 588588 588588 Kebull, Robert, of Bykelyswade, fisher 2
5374771 2467703 2467703 defendant Baldewyn John husbandman 588588 588588 Baldewyn, John, of Bykelyswade, husbandman 0
5374773 2467703 2467703 defendant Hill John husbandman 588588 588588 Hill, John, of Bykelyswade, husbandman 2
5529627 2513766 2513766 defendant Emery John yeoman or shoemaker 588588 588588 Emery, John, of Bykelyswade, yeoman or shoemaker 0
5586626 2530854 2530854 defendant Bray Henry husbandman 588588 588588 Bray, Henry, of Bykelyswade, husbandman 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);