names

45 rows where place_id = 594005

✎ 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
3614141 1872088 1872088 defendant Frowde Robert   594005 594005 Frowde, Robert, of Wodehous, franklin 1
3614142 1872088 1872088 defendant Chubbe William husbandman 594005 594005 Chubbe, William, of Wodehous, husbandman 2
3619248 1873622 1873622 defendant Myddylcomme Robert yeoman 594005 594005 Myddylcomme, Robert, of Wodehous, or of Alvyngton, yeoman 0
3622691 1874626 1874626 defendant Courteney Edward esq 594005 594005 Courteney, Edward, of Wodehous, esq 0
3625159 1875404 1875404 defendant Scose Henry yeoman 594005 594005 Scose, Henry, of Wodehous, or of North Wysshe, yeoman 0
4443677 2182990 2182990 defendant Russel John   594005 594005 Russel, John, of Wodehous 0
4482784 2195322 2195322 defendant Stevynton John   594005 594005 Stevynton, John, of Wodehous 0
4490398 2197698 2197698 defendant Hare William   594005 594005 Hare, William, of Wodehous 0
4536472 2211682 2211682 defendant Coleman Adam   594005 594005 Coleman, Adam, of Wodehous 0
4546738 2214906 2214906 defendant Aleyn Thomas   594005 594005 Aleyn, Thomas, of Wodehous 0
4554114 2217210 2217210 plaintiff Goude John   594005 594005 Goude, John, of Wodehous by Andover, son of John 2
4557478 2218275 2218275 plaintiff Lane Constant in the (legal representative) 594005 594005 Lane, Constant in the, of Wodehous, executor of 0
4657786 2248320 2248320 defendant Broun William husbandman 594005 594005 Broun, William, of Wodehous, husbandman 0
4747026 2279633 2279633 defendant Cartwryght John   594005 594005 Cartwryght, John, of Wodehous, cartwright 4
4791545 2293449 2293449 defendant Stuffyn Ralph gent 594005 594005 Stuffyn, Ralph, of Wodehous, gent 2
4791546 2293449 2293449 defendant Mordon Robert husbandman 594005 594005 Mordon, Robert, of Wodehous, husbandman 3
4845501 2310106 2310106 defendant Conewey Grono husbandman 594005 594005 Conewey, Grono, of Wodehous, husbandman 0
4860018 2314503 2314503 defendant Batte Richard husbandman 594005 594005 Batte, Richard, of Wodehous, husbandman 0
4860019 2314503 2314503 defendant Batte William laborer 594005 594005 Batte, William, of Wodehous, laborer 1
4873063 2318530 2318530 defendant Conewey Grove husbandman 594005 594005 Conewey, Grove, of Wodehous, husbandman 0
4873064 2318530 2318530 defendant Conewey Thomas   594005 594005 Conewey, Thomas, of Wodehous, servant, son of Grove 1
4873065 2318530 2318530 defendant Conewey John   594005 594005 Conewey, John, of Wodehous, servant, son of Grove 2
4908705 2329271 2329271 plaintiff atte Wode Thomas   594005 594005 atte Wode, Thomas, of Wodehous 0
4908706 2329271 2329271 defendant atte Wode Thomas   594005 594005 atte Wode, Thomas, of Wodehous 0
4926022 2334569 2334569 defendant de Bracheley John husbandman 594005 594005 de Bracheley, John, of Wodehous, husbandman 0
4926023 2334569 2334569 defendant Lynde John chapman 594005 594005 Lynde, John, of Wodehous, chapman 1
4951322 2342376 2342376 defendant Bratheley John husbandman 594005 594005 Bratheley, John, of Wodehous, husbandman 0
4951323 2342376 2342376 defendant Hyne or Hyve John chapman 594005 594005 Hyne or Hyve, John, of Wodehous, chapman 1
5088238 2382934 2382934 defendant White Amice widow 594005 594005 White, Amice, of Wodehous, widow 0
5131893 2395812 2395812 defendant Smyth Richard yeoman 594005 594005 Smyth, Richard, of Wodehous, yeoman 0
5170223 2407019 2407019 defendant Savage Henry yeoman 594005 594005 Savage, Henry, of Wodehous, yeoman 1
5189912 2412791 2412791 defendant Dove Thomas husbandman 594005 594005 Dove, Thomas, of Wodehous, husbandman 3
5296580 2443988 2443988 plaintiff Wode Thomas   594005 594005 Wode, Thomas, of Wodehous 0
5308002 2447410 2447410 defendant Wylson Robert yeoman 594005 594005 Wylson, Robert, of Wodehous, yeoman 1
5350554 2460291 2460291 defendant Chamberleyn John yeoman 594005 594005 Chamberleyn, John, of Wodehous, yeoman 3
5377543 2468561 2468561 defendant Wodde Thomas yeoman 594005 594005 Wodde, Thomas, of Wodehous, yeoman 1
5379107 2469060 2469060 defendant Owetrem John yeoman 594005 594005 Owetrem, John, of Wodehous, yeoman 4
5469053 2495672 2495672 defendant Were William laborer 594005 594005 Were, William, of Wodehous, laborer 0
5469054 2495672 2495672 defendant Quasshe Walter   594005 594005 Quasshe, Walter, of Wodehous, mason 1
5469055 2495672 2495672 defendant Bray John husbandman 594005 594005 Bray, John, of Wodehous, husbandman 2
5469057 2495672 2495672 defendant Marak John weaver 594005 594005 Marak, John, of Wodehous, weaver 4
5487855 2501256 2501256 defendant Paternoster alias Parker William slater or tiler 594005 594005 Paternoster alias Parker, William, of Wodehous, slater or tiler 0
5487856 2501256 2501256 defendant Dalton Robert husbandman 594005 594005 Dalton, Robert, of Wodehous, husbandman 1
5487857 2501256 2501256 defendant Asser Henry husbandman 594005 594005 Asser, Henry, of Wodehous, husbandman 2
5615158 2548534 2548534 defendant Russell John   594005 594005 Russell, John, of Wodehous 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);