names

39 rows where place_id = 600810

✎ 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
3642647 1908146 1908146 defendant Bocher John butcher 600810 600810 Bocher, John, of Brayles, butcher 1
3652337 1911067 1911067 defendant Robyns alias Bocher John butcher 600810 600810 Robyns alias Bocher, John, of Brayles, butcher 0
3652338 1911067 1911067 defendant Ryley Simon yeoman 600810 600810 Ryley, Simon, of Brayles, yeoman 1
3726982 1934708 1934708 defendant Bysshope William woolman 600810 600810 Bysshope, William, of Brayles, woolman 1
3736121 1937539 1937539 defendant Busshop William husbandman 600810 600810 Busshop, William, of Brayles, husbandman 0
3749493 1941752 1941752 defendant Bysshop William husbandman 600810 600810 Bysshop, William, of Brayles, husbandman 0
3841103 1970792 1970792 defendant Thovye Thomas yeoman 600810 600810 Thovye, Thomas, of Brayles, yeoman 1
3842794 1971278 1971278 defendant Burley Thomas clerk 600810 600810 Burley, Thomas, of Brayles, clerk 0
3912825 1994621 1994621 defendant Edward William smith 600810 600810 Edward, William, of Brayles, smith 3
3942797 2004595 2004595 defendant Dester William husbandman 600810 600810 Dester, William, of Brayles, husbandman 0
3942798 2004595 2004595 defendant Dester John husbandman 600810 600810 Dester, John, of Brayles, husbandman 1
4070511 2049745 2049745 defendant Bowlter William yeoman 600810 600810 Bowlter, William, of Brayles, yeoman 0
4146985 2077092 2077092 defendant Hambden Isabel   600810 600810 Hambden, Isabel, of Brayles 1
4213987 2100414 2100414 defendant Napton John yeoman 600810 600810 Napton, John, of Brayles, yeoman 1
4214377 2100535 2100535 defendant Goodson Agnes widow 600810 600810 Goodson, Agnes, of Brayles, widow 1
4224108 2103919 2103919 defendant Goodson William yeoman 600810 600810 Goodson William, of Brayles, yeoman 0
4277409 2122020 2122020 defendant Meadowe John carpenter 600810 600810 Meadowe, John, of Brayles, carpenter 1
4343543 2145019 2145019 defendant Allyn John husbandman 600810 600810 Allyn, John, of Brayles, or of Heddington, Oxon, husbandman 0
4374236 2155857 2155857 defendant Croft Lionel gent 600810 600810 Croft, Lionel, of Brayles, gent 2
4380216 2158029 2158029 defendant Baylie John yeoman 600810 600810 Baylie, John, of Brayles, yeoman 1
4400163 2164647 2164647 defendant Hemynge Roger husbandman 600810 600810 Hemynge, Roger, of Brayles, husbandman 0
4400165 2164648 2164648 defendant Hemynge Roger husbandman 600810 600810 Hemynge, Roger, of Brayles, husbandman 0
4441425 2182259 2182259 defendant Edden Thomas chaplain 600810 600810 Edden, Thomas, of Brayles, chaplain 0
4554827 2217435 2217435 plaintiff Handes John   600810 600810 Handes, John, of Brayles 0
4634234 2241549 2241549 defendant Cardell John   600810 600810 Cardell, John, of Brayles 0
4634813 2241740 2241740 defendant Cardell John   600810 600810 Cardell, John, of Brayles 0
4777512 2288961 2288961 plaintiff Bailly Walter   600810 600810 Bailly, Walter, of Brayles 0
4922002 2333291 2333291 defendant Webbe William weaver 600810 600810 Webbe, William, of Brayles, weaver 0
5089684 2383356 2383356 defendant Wilkys alias Bocher Robert yeoman 600810 600810 Wilkys alias Bocher, Robert, of Brayles, yeoman 1
5120851 2392530 2392530 defendant Huchman Robert husbandman 600810 600810 Huchman, Robert, of Brayles, husbandman 1
5311249 2448390 2448390 defendant Person Richard yeoman 600810 600810 Person, Richard, of Brayles, yeoman 0
5364653 2464605 2464605 defendant Heth John yeoman 600810 600810 Heth, John, of Brayles, yeoman 0
5370852 2466472 2466472 defendant Heth John yeoman 600810 600810 Heth, John, of Brayles, yeoman 0
5382559 2470073 2470073 defendant Yardeley Thomas clerk 600810 600810 Yardeley, Thomas, of Brayles, clerk 0
5521967 2511686 2511686 defendant Gibbis William laborer 600810 600810 Gibbis, William, of Brayles, laborer 0
5552224 2520694 2520694 defendant Ryley Simon husbandman 600810 600810 Ryley, Simon, of Brayles, husbandman 6
5552225 2520694 2520694 defendant Ball Edmund husbandman 600810 600810 Ball, Edmund, of Brayles, husbandman 7
5552226 2520694 2520694 defendant Davy Henry husbandman 600810 600810 Davy, Henry, of Brayles, husbandman 8
5552227 2520694 2520694 defendant Lee Thomas laborer 600810 600810 Lee, Thomas, of Brayles, laborer 9

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