names

37 rows where place_id = 600263

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3640335 1907408 1907408 defendant Rayne John husbandman 600263 600263 Rayne, John, of Merworth, husbandman 0
3683289 1920896 1920896 defendant Moyse Thomas miller 600263 600263 Moyse, Thomas, of Merworth, miller 0
3716091 1931317 1931317 defendant Bowerman Thomas husbandman 600263 600263 Bowerman, Thomas, of Merworth, husbandman 3
3751274 1942322 1942322 defendant Turk John (legal representative) 600263 600263 Turk, John, of Merworth, executor of 0
3759603 1944993 1944993 defendant Bacheler William thatcher 600263 600263 Bacheler, William, of Merworth, thatcher 0
4176752 2087338 2087338 defendant Brooke John yeoman 600263 600263 Brooke, John, of Merworth, yeoman 0
4321873 2137735 2137735 defendant Hunt John   600263 600263 Hunt, John, of Merworth, mason 0
4616292 2236087 2236087 defendant Yonge John   600263 600263 Yonge, John, of Merworth 0
4641456 2243599 2243599 defendant Yonge John   600263 600263 Yonge, John, of Merworth 0
4749821 2280422 2280422 defendant Parker Peter yeoman 600263 600263 Parker, Peter, of Merworth, yeoman 1
5025188 2364262 2364262 defendant Chamberleyn Robert husbandman 600263 600263 Chamberleyn, Robert, of Merworth, husbandman 1
5045165 2370184 2370184 defendant Chamberleyn Robert husbandman 600263 600263 Chamberleyn, Robert, of Merworth, husbandman 0
5056641 2373558 2373558 defendant Colier Robert husbandman 600263 600263 Colier, Robert, of Merworth, husbandman 6
5056642 2373558 2373558 defendant Taillour Thomas husbandman 600263 600263 Taillour, Thomas, of Merworth, husbandman 7
5056643 2373558 2373558 defendant Payn Henry yeoman 600263 600263 Payn, Henry, of Merworth, yeoman 8
5083431 2381541 2381541 defendant Chamberleyn Walter yeoman of the king 600263 600263 Chamberleyn, Walter, of Merworth, yeoman of the king 1
5087707 2382791 2382791 defendant Chamberleyn Walter yeoman of the crown 600263 600263 Chamberleyn, Walter, of Merworth, yeoman of the crown 1
5235861 2426068 2426068 defendant Turke Thomas (legal representative) 600263 600263 Turke, Thomas, of Merworth, drover, executors of 2
5235863 2426068 2426068 defendant Berworth Mary widow 600263 600263 Berworth, Mary, of Merworth, widow 4
5238348 2426803 2426803 defendant Neuman John husbandman 600263 600263 Neuman, John, of Merworth, husbandman 2
5252431 2430870 2430870 defendant Neweman John husbandman 600263 600263 Neweman, John, of Merworth, chapman, son of Neweman, Reginald, of Kemsyng, or of Merworth, husbandman 0
5252432 2430870 2430870 defendant Scantlon John husbandman 600263 600263 Scantlon, John, of Merworth, husbandman 1
5332404 2454757 2454757 defendant Cattys John gent 600263 600263 Cattys, John, of Merworth, gent 0
5332405 2454757 2454757 defendant Broune Alice widow 600263 600263 together with Broune, Alice, of Merworth, widow 1
5332410 2454758 2454758 plaintiff Cattys John gent 600263 600263 together with Cattys, John, of Merworth, gent 4
5332411 2454758 2454758 defendant Broune Alice widow 600263 600263 Broune, Alice, of Merworth, widow 0
5344586 2458473 2458473 defendant Haccher Walter husbandman 600263 600263 Haccher, Walter, of Merworth, husbandman 0
5344588 2458474 2458474 defendant Haccher Walter husbandman 600263 600263 Haccher, Walter, of Merworth, husbandman 0
5487369 2501116 2501116 defendant Taylour Roger husbandman 600263 600263 Taylour, Roger, of Merworth, husbandman 0
5501571 2505421 2505421 defendant Hacche Walter husbandman 600263 600263 Hacche, Walter, of Merworth, husbandman 0
5501572 2505421 2505421 defendant Somer Thomas husbandman 600263 600263 Somer, Thomas, of Merworth, husbandman 1
5501573 2505421 2505421 defendant Turke Thomas husbandman 600263 600263 Turke, Thomas, of Merworth, husbandman 2
5502685 2505757 2505757 plaintiff Turk John husbandman 600263 600263 Turk, John, of Merworth, husbandman 0
5502687 2505758 2505758 plaintiff Turke John husbandman 600263 600263 Turke, John, of Merworth, husbandman 0
5631393 2553822 2553822 defendant Cryell Bartholomew husbandman 600263 600263 Cryell, Bartholomew, of Merworth, husbandman 1
5631394 2553822 2553822 defendant Waryn William husbandman 600263 600263 Waryn, William, of Merworth, husbandman 2
5631395 2553822 2553822 defendant Waryn John husbandman 600263 600263 Waryn, John, of Merworth, husbandman 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);