names

45 rows where place_id = 626443

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3770156 1948333 1948333 defendant Collyns Thomas shoemaker 626443 626443 Collyns, Thomas, of Brendewode, Essex, shoemaker 0
4651207 2246383 2246383 defendant Boys Henry ostler 626443 626443 Boys, Henry, of Brendewode, Essex, ostler 0
4669252 2256089 2256089 defendant Payn Thomas yeoman 626443 626443 Payn, Thomas, of Brendewode, Essex, yeoman 0
4722003 2272212 2272212 defendant Writeil John chapman 626443 626443 Writeil, John, of Brendewode, Essex, chapman 1
4790952 2293262 2293262 defendant Flemmyng Henry tailor 626443 626443 Flemmyng, Henry, of Brendewode, Essex, tailor 0
4817612 2301596 2301596 defendant Richard John ostler 626443 626443 Richard, John, of Brendewode, Essex, ostler 3
4817621 2301598 2301598 defendant Richard John ostler 626443 626443 Richard, John, of Brendewode, Essex, ostler 3
4825117 2303898 2303898 defendant Wyghte Richard hostler 626443 626443 Wyghte, Richard, of Brendewode, Essex, hostler 0
4877821 2320026 2320026 defendant Richard John ostler 626443 626443 Richard, John, of Brendewode, Essex, ostler 1
4889792 2323600 2323600 defendant Gylosse Thomas ripier or fishmonger 626443 626443 Gylosse, Thomas, of Brendewode, Essex, ripier or fishmonger 1
4894720 2325020 2325020 defendant Stamford John   626443 626443 Stamford, John, of Brendewode, Essex 0
4907430 2328885 2328885 defendant Staunford John gent 626443 626443 Staunford, John, of Brendewode, Essex, gent 0
4928896 2335459 2335459 defendant Cotermonge John yeoman 626443 626443 Cotermonge, John, of Brendewode, Essex, yeoman 0
4938891 2338555 2338555 defendant Richard John ostler 626443 626443 Richard, John, of Brendewode, Essex, ostler 0
4948328 2341457 2341457 defendant Richard John hosteler 626443 626443 Richard, John, of Brendewode, Essex, hosteler 0
4956442 2343884 2343884 defendant Staunford John gent 626443 626443 Staunford, John, of Brendewode, Essex, gent 0
5019848 2362684 2362684 defendant Staunford John gent 626443 626443 Staunford, John, of Brendewode, Essex, gent 3
5060951 2374845 2374845 defendant Rychard John ostler 626443 626443 Rychard, John, of Brendewode, Essex, ostler 2
5134743 2396660 2396660 defendant Bap--- John tailor 626443 626443 Bap---, John, of Brendewode, Essex, tailor 0
5137386 2397447 2397447 defendant Abbot Thomas chapman 626443 626443 Abbot, Thomas, of Brendewode, Essex, chapman 1
5256998 2432318 2432318 defendant Dalby John chapman 626443 626443 Dalby, John, of Brendewode, Essex, chapman 2
5265269 2434897 2434897 defendant Brokke Thomas salter 626443 626443 Brokke, Thomas, of Brendewode, Essex, salter 0
5288166 2441557 2441557 defendant Byrde John tailor 626443 626443 Byrde, John, of Brendewode, Essex, tailor 3
5309405 2447853 2447853 defendant Cheven John yeoman 626443 626443 Cheven, John, of Brendewode, Essex, yeoman 1
5309409 2447854 2447854 defendant Chenen or Cheven John yeoman 626443 626443 Chenen or Cheven, John, of Brendewode, Essex, yeoman 2
5317256 2450242 2450242 defendant Goman John husbandman 626443 626443 Goman, John, of Brendewode, Essex, husbandman 1
5319954 2451053 2451053 defendant Baldewyn Thomas yeoman 626443 626443 Baldewyn, Thomas, of Brendewode, Essex, yeoman 0
5340219 2457149 2457149 defendant Chenyn Thomas gent 626443 626443 Chenyn, Thomas, of Brendewode, Essex, gent 0
5354981 2461629 2461629 defendant Prentyse William yeoman 626443 626443 Prentyse, William, of Brendewode, Essex, yeoman 0
5367756 2465544 2465544 defendant Westwyke Thomas hosier 626443 626443 Westwyke, Thomas, of Brendewode, Essex, hosier 4
5375178 2467825 2467825 defendant Fuller Edmund   626443 626443 Fuller, Edmund, of Brendewode, Essex, parish clerk 0
5398456 2474617 2474617 defendant Westwyke Thomas hosier 626443 626443 Westwyke, Thomas, of Brendewode, Essex, hosier 2
5411595 2478423 2478423 defendant Westwyk Thomas hosier 626443 626443 Westwyk, Thomas, of Brendewode, Essex, hosier 3
5425890 2482704 2482704 defendant Westwyk Thomas hosier 626443 626443 Westwyk, Thomas, of Brendewode, Essex, hosier 3
5425896 2482705 2482705 defendant Westwyk Thomas hosier 626443 626443 Westwyk, Thomas, of Brendewode, Essex, hosier 3
5440182 2486963 2486963 defendant Chevyn John gent 626443 626443 Chevyn, John, of Brendewode, Essex, gent 0
5453628 2490976 2490976 defendant Chevyn John gent 626443 626443 Chevyn, John, of Brendewode, Essex, gent 0
5465562 2494606 2494606 defendant Chevyn John gent 626443 626443 Chevyn, John, of Brendewode, Essex, gent 0
5482496 2499708 2499708 defendant Lee John yeoman 626443 626443 Lee, John, of Brendewode, Essex, yeoman 1
5488216 2501374 2501374 defendant Base John carpenter 626443 626443 Base, John, of Brendewode, Essex, carpenter 0
5517897 2510441 2510441 defendant Chevyn John gent 626443 626443 Chevyn, John, of Brendewode, Essex, gent 0
5540257 2517080 2517080 defendant Wymber Thomas yeoman 626443 626443 Wymber, Thomas, of Brendewode, Essex, yeoman 1
5545492 2518672 2518672 defendant Olyver Humphrey innholder 626443 626443 Olyver, Humphrey, of Brendewode, Essex, innholder 1
5547653 2519329 2519329 defendant Baldewyn John butcher 626443 626443 Baldewyn, John, of Brendewode, Essex, butcher 1
5547660 2519330 2519330 defendant Baldewyn John butcher 626443 626443 Baldewyn, John, of Brendewode, Essex, butcher 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);