names

44 rows where place_id = 599896

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3638704 1906920 1906920 defendant Grene Thomas yeoman 599896 599896 Grene, Thomas, of Colshill, yeoman 1
3675806 1918466 1918466 defendant Bodeley John yeoman 599896 599896 Bodeley, John, of Colshill, yeoman 3
3784753 1953023 1953023 defendant Shawe William chaplain 599896 599896 Shawe, William, of Colshill, chaplain 0
3862154 1977526 1977526 defendant Sharman Thomas yeoman 599896 599896 Sharman, Thomas, of Colshill, yeoman 2
4023906 2033254 2033254 plaintiff Belhurst Reginald yeoman 599896 599896 Belhurst, Reginald, of Colshill, yeoman 0
4189566 2091851 2091851 defendant Wingrave John husbandman 599896 599896 Wingrave, John, of Colshill, husbandman 0
4257042 2115329 2115329 defendant Fytche John gent 599896 599896 Fytche, John, of Colshill, gent 0
4257044 2115330 2115330 defendant Head Nicholas yeoman 599896 599896 Head, Nicholas, of Colshill, yeoman 0
4276882 2121842 2121842 defendant Fytche John gent 599896 599896 Fytche, John, of Colshill, gent 0
4371617 2154903 2154903 defendant Keeling John blacksmith 599896 599896 Keeling, John, of Colshill, blacksmith 0
4392936 2162250 2162250 defendant Cowper John yeoman 599896 599896 Cowper, John, of Colshill, yeoman 0
4620508 2237392 2237392 defendant Cokkes Letitia   599896 599896 Cokkes, Letitia, of Colshill, formerly wife of Robert 0
4620512 2237394 2237394 defendant Cokkes Letitia   599896 599896 Cokkes, Letitia, of Colshill, formerly wife of Robert 0
4643629 2244237 2244237 defendant Colyer Roger   599896 599896 Colyer, Roger, of Colshill 1
4645155 2244652 2244652 plaintiff More John   599896 599896 More, John, of Colshill 0
4769953 2286575 2286575 defendant Alyen John   599896 599896 Alyen, John, of Colshill, bailiff 2
4843153 2309386 2309386 defendant Clement Richard yeoman 599896 599896 Clement, Richard, of Colshill, yeoman 0
4843154 2309386 2309386 defendant Grendon William yeoman 599896 599896 Grendon, William, of Colshill, yeoman 1
4892423 2324370 2324370 defendant Treweman Thomas whitawer 599896 599896 Treweman, Thomas, of Colshill, whitawer 0
4930234 2335859 2335859 plaintiff Thorp Hugh   599896 599896 Thorp, Hugh, of Colshill 0
5058293 2374030 2374030 defendant Chapman Thomas chapman 599896 599896 Chapman, Thomas, of Colshill, chapman 1
5058294 2374030 2374030 defendant Baker Thomas yeoman 599896 599896 Baker, Thomas, of Colshill, yeoman 2
5063232 2375533 2375533 defendant Hawenell Richard yeoman 599896 599896 Hawenell, Richard, of Colshill, yeoman 0
5074258 2378791 2378791 plaintiff Whatton Thomas   599896 599896 Whatton, Thomas, of Colshill 0
5095374 2385068 2385068 defendant Mountford William (legal representative) 599896 599896 Mountford, William, of Colshill, knight, executors of 0
5113726 2390409 2390409 defendant of the Seler alias Burton Thomas yeoman 599896 599896 of the Seler alias Burton, Thomas, of Colshill, yeoman 0
5113728 2390410 2390410 defendant of the Seler alias Burton Thomas yeoman 599896 599896 of the Seler alias Burton, Thomas, of Colshill, yeoman 0
5143253 2399165 2399165 plaintiff Agot William   599896 599896 Agot, William, of Colshill 0
5143259 2399166 2399166 plaintiff Agot William   599896 599896 Agot, William, of Colshill 0
5164576 2405372 2405372 plaintiff Agot William   599896 599896 Agot, William, of Colshill 0
5177885 2409238 2409238 plaintiff Agot William   599896 599896 Agot, William, of Colshill 0
5177887 2409239 2409239 plaintiff Agot William   599896 599896 Agot, William, of Colshill 0
5177891 2409240 2409240 plaintiff Agot William   599896 599896 Agot, William, of Colshill 0
5235348 2425918 2425918 defendant Parfyte John miller 599896 599896 Parfyte, John, of Colshill, miller 6
5300958 2445238 2445238 defendant Abell William clerk 599896 599896 Abell, William, of Colshill, clerk 0
5300959 2445238 2445238 defendant Helde William smith 599896 599896 Helde, William, of Colshill, smith 1
5300960 2445238 2445238 defendant Walker Peter sheerman 599896 599896 Walker, Peter, of Colshill, sheerman 2
5303924 2446179 2446179 defendant Coke Thomas yeoman 599896 599896 Coke, Thomas, of Colshill, yeoman 0
5303925 2446179 2446179 defendant Coke Richard tailor 599896 599896 Coke, Richard, of Colshill, tailor 1
5303926 2446179 2446179 defendant Crosse John walker 599896 599896 Crosse, John, of Colshill, walker 2
5303927 2446179 2446179 defendant Burton Thomas yeoman 599896 599896 Burton, Thomas, of Colshill, yeoman 3
5311158 2448365 2448365 defendant Wodward Thomas shoemaker 599896 599896 Wodward, Thomas, of Colshill, shoemaker 0
5383881 2470475 2470475 defendant Crosse John walker 599896 599896 Crosse, John, of Colshill, walker 3
5554297 2521295 2521295 defendant Huse Beatrice widow 599896 599896 (Huse, Beatrice, of Colshill, widow 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);