names

41 rows where place_id = 595547

✎ 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
3615279 1872424 1872424 defendant Grene Thomas   595547 595547 Grene, Thomas, of Norton Davy, knight 0
3615281 1872425 1872425 defendant Grene Thomas   595547 595547 Grene, Thomas, of Norton Davy, knight 0
3620970 1874122 1874122 defendant Grene Thomas   595547 595547 Grene, Thomas, of Norton Davy, knight 0
3620971 1874122 1874122 defendant Knyghtley John gent 595547 595547 Knyghtley, John, of Norton Davy, gent 1
3620972 1874122 1874122 defendant Thorne John gent 595547 595547 Thorne, John, of Norton Davy, gent 2
3620973 1874122 1874122 defendant Dough David yeoman 595547 595547 Dough, David, of Norton Davy, yeoman 3
3624609 1875236 1875236 defendant Grene Thomas   595547 595547 Grene, Thomas, of Norton Davy, knight 0
3624610 1875236 1875236 defendant Knyghtley John gent 595547 595547 Knyghtley, John, of Norton Davy, gent 1
3624611 1875236 1875236 defendant Thorne John gent 595547 595547 Thorne, John, of Norton Davy, gent 2
3624612 1875236 1875236 defendant Dough David yeoman 595547 595547 Dough, David, of Norton Davy, yeoman 3
3712161 1930121 1930121 defendant Byrt Thomas husbandman 595547 595547 Byrt, Thomas, of Norton Davy, husbandman 2
4477143 2193514 2193514 plaintiff Golford or Golsore Richard (legal representative) 595547 595547 Golford or Golsore, Richard, of Norton Davy, executors of 0
4688473 2261962 2261962 defendant Cok John   595547 595547 Cok, John, of Norton Davy, parson 0
4688474 2261962 2261962 defendant Landwath Thomas chaplain 595547 595547 Landwath, Thomas, of Norton Davy, chaplain 1
4800785 2296433 2296433 defendant Grene Mary   595547 595547 Grene, Mary, of Norton Davy, gentlewoman, diwod of Grene, Thomas, knight 0
4839214 2308192 2308192 defendant Chese John yeoman 595547 595547 Chese, John, of Norton Davy, yeoman 0
4839215 2308192 2308192 defendant Tebber John yeoman 595547 595547 Tebber, John, of Norton Davy, yeoman 1
4839216 2308192 2308192 defendant Cook Richard yeoman 595547 595547 Cook, Richard, of Norton Davy, yeoman 2
4889006 2323352 2323352 defendant Boughton Richard husbandman 595547 595547 Boughton, Richard, of Norton Davy, husbandman 1
4911368 2330058 2330058 defendant Boghon Thomas   595547 595547 Boghon, Thomas, of Norton Davy, parson 2
4911393 2330065 2330065 defendant Boghton Thomas   595547 595547 Boghton, Thomas, of Norton Davy, parson 2
4911397 2330066 2330066 defendant Boghton Thomas   595547 595547 Boghton, Thomas, of Norton Davy, parson 2
5032586 2366415 2366415 defendant Broke Arthur gent 595547 595547 Broke, Arthur, of Norton Davy, gent 1
5034873 2367056 2367056 defendant Boughton Thomas clerk 595547 595547 Boughton, Thomas, of Norton Davy, clerk 0
5034877 2367057 2367057 defendant Boughton Thomas clerk 595547 595547 Boughton, Thomas, of Norton Davy, clerk 0
5046188 2370490 2370490 defendant Smyth John husbandman 595547 595547 Smyth, John, of Norton Davy, husbandman 0
5046189 2370490 2370490 defendant Hurre William yeoman 595547 595547 Hurre, William, of Norton Davy, yeoman 1
5046191 2370490 2370490 defendant Ray Simon husbandman 595547 595547 Ray, Simon, of Norton Davy, husbandman 3
5055299 2373170 2373170 defendant Capron John husbandman 595547 595547 Capron, John, of Norton Davy, husbandman 1
5055300 2373170 2373170 defendant Wenkles Geoffrey husbandman 595547 595547 Wenkles, Geoffrey, of Norton Davy, husbandman 2
5055301 2373170 2373170 defendant Wardon Henry laborer 595547 595547 Wardon, Henry, of Norton Davy, laborer 3
5111021 2389615 2389615 defendant Boughton Thomas clerk 595547 595547 Boughton, Thomas, of Norton Davy, clerk 1
5256710 2432219 2432219 defendant FitzWillyam Richard gent 595547 595547 FitzWillyam, Richard, of Norton Davy, gent 3
5387099 2471378 2471378 defendant Flesshewere William clerk 595547 595547 Flesshewere, William, of Norton Davy, clerk 1
5399516 2474941 2474941 defendant Flesshewere William clerk 595547 595547 Flesshewere, William, of Norton Davy, clerk 1
5440714 2487132 2487132 defendant Wykyns Thomas husbandman 595547 595547 Wykyns, Thomas, of Norton Davy, husbandman 0
5440715 2487132 2487132 defendant Smyth John husbandman 595547 595547 Smyth, John, of Norton Davy, husbandman 1
5453682 2490995 2490995 defendant Wykyns Thomas husbandman 595547 595547 Wykyns, Thomas, of Norton Davy, husbandman 0
5465857 2494705 2494705 defendant Scote John yeoman 595547 595547 Scote, John, of Norton Davy, yeoman 3
5477332 2498230 2498230 defendant Scote John yeoman 595547 595547 Scote, John, of Norton Davy, yeoman 3
5521272 2511472 2511472 defendant Grene Thomas   595547 595547 Grene, Thomas, of Norton Davy, knight 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);