names

40 rows where place_id = 591134

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3603433 1868740 1868740 defendant Grey Thomas husbandman 591134 591134 Grey, Thomas, of Est Tudenham, husbandman 2
3604016 1868922 1868922 defendant Attewell Thomas yeoman 591134 591134 Attewell, Thomas, of Est Tudenham, yeoman 1
3605553 1869403 1869403 defendant Butte John husbandman 591134 591134 (Butte, John, of Est Tudenham, husbandman 1
3636375 1906166 1906166 defendant Smyth Peter husbandman 591134 591134 Smyth, Peter, of Est Tudenham, husbandman 0
3723123 1933498 1933498 defendant Tylney Richard husbandman 591134 591134 Tylney, Richard, of Est Tudenham, husbandman 0
3760363 1945245 1945245 defendant Proo John husbandman 591134 591134 Proo, John, of Est Tudenham, husbandman 0
3767521 1947479 1947479 defendant Proo John husbandman 591134 591134 Proo, John, of Est Tudenham, husbandman 0
3785259 1953174 1953174 defendant Proo John husbandman 591134 591134 (Proo, John, of Est Tudenham, husbandman 1
3785702 1953320 1953320 defendant Proo John husbandman 591134 591134 Proo, John, of Est Tudenham, husbandman 0
3787938 1954021 1954021 defendant Wyte Robert yeoman 591134 591134 Wyte, Robert, of Est Tudenham, yeoman 0
3795546 1956489 1956489 defendant Crowlande Thomas yeoman 591134 591134 Crowlande, Thomas, of Est Tudenham, yeoman 0
3837264 1969562 1969562 defendant Hatley Robert husbandman 591134 591134 Hatley, Robert, of Est Tudenham, husbandman 0
3919862 1996976 1996976 defendant Shanke Thomas yeoman 591134 591134 Shanke, Thomas, of Est Tudenham, yeoman 0
4008093 2027659 2027659 plaintiff Mayne Henry laborer 591134 591134 Mayne, Henry, of Est Tudenham, laborer 0
4229476 2105794 2105794 defendant Deane Thomas yeoman 591134 591134 Deane, Thomas, of East Tudenham, yeoman 0
4420654 2171357 2171357 defendant Marytn Andrew   591134 591134 Marytn, Andrew, of East Tudenham 0
4608519 2233772 2233772 defendant atte Feeld John   591134 591134 atte Feeld, John, of East Tudenham 1
4608520 2233772 2233772 defendant atte Welle Benedict   591134 591134 atte Welle, Benedict, of East Tudenham 2
4648001 2245482 2245482 plaintiff atte Well Benedict   591134 591134 atte Well, Benedict, of East Tudenham 1
4648002 2245482 2245482 defendant Sterlyng Thomas   591134 591134 Sterlyng, Thomas, of East Tudenham 0
4648003 2245482 2245482 defendant Smyth Thomas   591134 591134 Smyth, Thomas, of East Tudenham 1
4724281 2272890 2272890 defendant Nobbys John yeoman 591134 591134 Nobbys, John, of East Tudenham, yeoman 0
4724283 2272891 2272891 defendant Nobbys John yeoman 591134 591134 Nobbys, John, of East Tudenham, yeoman 0
4740137 2277633 2277633 plaintiff atte Hawe William   591134 591134 atte Hawe, William, of East Tudenham 0
4743533 2278636 2278636 defendant Nobbys John husbandman 591134 591134 Nobbys, John, of East Tudenham, husbandman 0
4857456 2313720 2313720 defendant Nutte Simon yeoman 591134 591134 Nutte, Simon, of Est Tudenham, yeoman 2
5036558 2367555 2367555 defendant Waleys Richard   591134 591134 Waleys, Richard, of Est Tudenham 0
5225924 2423254 2423254 defendant Whitenham Richard husbandman 591134 591134 Whitenham, Richard, of Est Tudenham, husbandman 0
5230040 2424400 2424400 defendant Charles Henry husbandman 591134 591134 Charles, Henry, of Est Tudenham, husbandman 0
5273428 2437301 2437301 defendant Charlys Henry yeoman 591134 591134 Charlys, Henry, of East Tudenham, yeoman 0
5301758 2445482 2445482 defendant Symond William husbandman 591134 591134 Symond, William, of East Tudenham, husbandman 6
5379995 2469330 2469330 plaintiff Attewelle Thomas   591134 591134 Attewelle, Thomas, of East Tudenham 0
5379999 2469331 2469331 plaintiff Attewelle Thomas   591134 591134 Attewelle, Thomas, of East Tudenham 0
5426173 2482781 2482781 defendant Wylde John husbandman 591134 591134 Wylde, John, of East Tudenham, husbandman 1
5448399 2489416 2489416 defendant Butte John husbandman 591134 591134 Butte, John, of East Tudenham, husbandman 0
5448400 2489416 2489416 defendant Clerk Thomas husbandman 591134 591134 Clerk, Thomas, of East Tudenham, husbandman 1
5477389 2498252 2498252 defendant Butte John husbandman 591134 591134 Butte, John, of East Tudenham, husbandman 0
5477390 2498252 2498252 defendant Clerk Thomas husbandman 591134 591134 Clerk, Thomas, of East tudenham, husbandman 1
5479168 2498791 2498791 defendant Wylde John laborer 591134 591134 Wylde, John, of Est Tudenham, laborer 6
5515256 2509617 2509617 defendant N- Simon   591134 591134 (N-, Simon, of Est Tudenham 3

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