names

26 rows where place_id = 768191

✎ 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
4546846 2214941 2214941 plaintiff Brugge Richard   768191 768191 Brugge, Richard, of Chepyng Sobbury 0
4745531 2279204 2279204 defendant Tanner William tanner 768191 768191 Tanner, William, of Chepyng Sobbury, tanner 0
4804080 2297463 2297463 defendant Wyltesshyre Richard yeoman 768191 768191 Wyltesshyre, Richard, of Chepyng Sobbury, yeoman 0
4859921 2314474 2314474 plaintiff Chaundeler John   768191 768191 Chaundeler, John, of Chepyng Sobbury 0
4865069 2316050 2316050 defendant Peynter Richard painter 768191 768191 Peynter, Richard, of Chepyng Sobbury, painter 1
4904845 2328114 2328114 defendant Burnell John yeoman 768191 768191 Burnell, John, of Chepyng Sobbury, yeoman 0
4910054 2329667 2329667 defendant Tayllour Edmung tailor 768191 768191 Tayllour, Edmung, of Chepyng sobbury, tailor 1
4910055 2329667 2329667 defendant Punsard John   768191 768191 Punsard, John, of Chepyng Sobbury, servant 2
4910061 2329668 2329668 defendant Taillour Edmund tailor 768191 768191 Taillour, Edmund, of Chepyng Sobbury, tailor 1
4910062 2329668 2329668 defendant Punsard John   768191 768191 Punsard, John, of Chepyng Sobbury, servant 2
4928175 2335241 2335241 defendant Hayward John butcher 768191 768191 Hayward, John, of Chepyng Sobbury, butcher 0
4973980 2349179 2349179 defendant Grene Robert husbandman 768191 768191 Grene, Robert, of Chepyng Sobbury, husbandman 6
4987423 2353193 2353193 defendant Milward John pygheler or pig healer 768191 768191 Milward, John, of Chepyng Sobbury, pygheler or pig healer 2
5013636 2360830 2360830 defendant Godston Thomas, junior dyer 768191 768191 Godston, Thomas, junior, of Chepyng Sobbury, dyer 0
5103783 2387530 2387530 defendant Bocher Thomas butcher 768191 768191 Bocher, Thomas, of Chepyng Sobbury, butcher 0
5108945 2389035 2389035 defendant Byde Walter laborer 768191 768191 Byde, Walter, of Chepyng Sobbury, laborer 4
5108946 2389035 2389035 defendant Prewet Thomas husbandman 768191 768191 Prewet, Thomas, of Chepyng Sobbury, husbandman 5
5108947 2389035 2389035 defendant Chaundeler John carrier 768191 768191 Chaundeler,John, of Chepyng Sobbury, carrier 6
5319518 2450931 2450931 defendant Longford John yeoman 768191 768191 Longford, John, of Chepyng Sobbury, yeoman 1
5378954 2469012 2469012 defendant Jones Hugh butcher 768191 768191 Jones, Hugh, of Chepyng Sobbury, butcher 0
5494334 2503207 2503207 defendant Stanschawe Richard gent 768191 768191 Stanschawe, Richard, of Chepyng Sobbury, gent 0
5494337 2503207 2503207 defendant Adams Richard tailor 768191 768191 Adams, Richard, of Chepyng Sobbury, tailor 3
5494338 2503207 2503207 defendant Gough Henry yeoman 768191 768191 Gough, Henry, of Chepyng Sobbury, yeoman 4
5494339 2503207 2503207 defendant Francom John husbandman 768191 768191 Francom, John, of Chepyng Sobbury, husbandman 5
5625223 2551828 2551828 defendant Cook John tailor 768191 768191 Cook, John, of Chepyng Sobbury, tailor 0
5625224 2551828 2551828 defendant Grynder John cooper 768191 768191 Grynder, John, of Chepyng Sobbury, cooper 1

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