names

72 rows where place_id = 691676

✎ 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
4091123 2057111 2057111 defendant Sache William husbandman 691676 691676 Sache, William, of Borham, husbandman 2
4431941 2174769 2174769 defendant Sherrene John   691676 691676 Sherrene, John, of Borham 0
4438916 2181465 2181465 defendant Derby John, junior   691676 691676 Derby, John, junior, of Borham 0
4438918 2181465 2181465 defendant Kyng John butcher 691676 691676 Kyng, John, of Borham, butcher 2
4457872 2187483 2187483 plaintiff Porter Robert   691676 691676 Porter, Robert, of Borham 0
4457875 2187484 2187484 plaintiff Porter Robert   691676 691676 Porter, Robert, of Borham 0
4459839 2188131 2188131 defendant Mody Adam   691676 691676 Mody, Adam, of Borham 0
4459840 2188131 2188131 defendant Derby John, junior   691676 691676 Derby, John, junior, of Borham 1
4470309 2191362 2191362 plaintiff Brikhell John   691676 691676 Brikhell, John, of Borham 0
4516322 2205515 2205515 plaintiff Colbrand John   691676 691676 Colbrand, John, of Borham 0
4524044 2207853 2207853 defendant Colbrond John   691676 691676 Colbrond, John, of Borham 1
4524047 2207854 2207854 defendant Colbrond John   691676 691676 Colbrond, John, of Borham 0
4525973 2208424 2208424 defendant Aubry John   691676 691676 Aubry, John, of Borham 1
4534631 2211102 2211102 plaintiff Reedhood Thomas   691676 691676 Reedhood, Thomas, of Borham 1
4557122 2218156 2218156 defendant Aubre John   691676 691676 Aubre, John, of Borham 0
4591376 2228657 2228657 defendant Webbe John   691676 691676 Webbe, John, of Borham 0
4623819 2238425 2238425 defendant Brid John   691676 691676 Brid, John, of Borham 1
4627204 2239454 2239454 defendant atte Welle William   691676 691676 atte Welle, William, of Borham 0
4632919 2241167 2241167 defendant Mageson alias Page John   691676 691676 Mageson alias Page, John, of Borham 2
4634817 2241742 2241742 defendant Sote Simon   691676 691676 Sote, Simon, of Borham 0
4638615 2242831 2242831 defendant Shereve John   691676 691676 Shereve, John, of Borham 3
4643703 2244258 2244258 defendant Bogays John   691676 691676 Bogays, John, of Borham 2
4653460 2247013 2247013 defendant Lampham John, senior   691676 691676 Lampham, John, senior, of Borham 0
4657950 2248370 2248370 defendant Aubre John husbandman 691676 691676 Aubre, John, of Borham, husbandman 0
4657952 2248371 2248371 defendant Aubre John husbandman 691676 691676 Aubre, John, of Borham, husbandman 0
4665499 2250682 2250682 defendant Hane or Have Roger tailor 691676 691676 Hane or Have, Roger, of Borham, tailor 0
4735286 2276183 2276183 defendant Pecche John smith 691676 691676 Pecche, John, of Borham, smith 1
4747141 2279669 2279669 defendant Ardelegh John butcher 691676 691676 Ardelegh, John, of Borham, butcher 0
4759613 2283352 2283352 plaintiff Clerk John   691676 691676 Clerk, John, of Borham 0
4765749 2285283 2285283 defendant Palmer John   691676 691676 Palmer, John, of Borham, bailiff 0
4784880 2291278 2291278 defendant Porter Robert yeoman 691676 691676 Porter, Robert, of Borham, yeoman 4
4807542 2298551 2298551 defendant Haukyn William laborer 691676 691676 Haukyn, William, of Borham, laborer 0
4820350 2302434 2302434 defendant Barbour John yeoman 691676 691676 Barbour, John, of Borham, yeoman 0
4840121 2308458 2308458 defendant Porter Robert gent 691676 691676 Porter, Robert, of Borham, gent 0
4840122 2308458 2308458 defendant Ardele John husbandman 691676 691676 Ardele, John, of Borham, husbandman 1
4867012 2316647 2316647 defendant Porter Robert gent 691676 691676 Porter, Robert, of Borham, gent 0
4867013 2316647 2316647 defendant Ardele John husbandman 691676 691676 Ardele, John, of Borham, husbandman 1
4887447 2322913 2322913 defendant Bryghtnot Thomas smith 691676 691676 Bryghtnot, Thomas, of Borham, smith 1
4914549 2331072 2331072 defendant Merty Thomas clerk 691676 691676 Merty, Thomas, of Borham, clerk 0
4915113 2331234 2331234 defendant Waleys Thomas butcher 691676 691676 Waleys, Thomas, of Borham, butcher 2
4934378 2337144 2337144 plaintiff atte Lay Richard   691676 691676 atte Lay, Richard, of Borham 0
4934382 2337146 2337146 plaintiff atte Melle Richard   691676 691676 atte Melle, Richard, of Borham 0
4954100 2343192 2343192 defendant Poyntour Thomas husbandman 691676 691676 Poyntour, Thomas, of Borham, husbandman 1
4954101 2343192 2343192 defendant Barbour John husbandman 691676 691676 Barbour, John, of Borham, husbandman 2
4954102 2343192 2343192 defendant Clerk John   691676 691676 Clerk, John, of Borham 3
4959654 2344849 2344849 plaintiff atte Mille Richard   691676 691676 atte Mille, Richard, of Borham 0
4963067 2345861 2345861 defendant Tendryng Thomas yeoman 691676 691676 together with Tendryng, Thomas, of Borham, yeoman 1
4963068 2345861 2345861 defendant Tendryng John yeoman 691676 691676 Tendryng, John, of Borham, yeoman 2
4974813 2349439 2349439 defendant Colbrond John gent 691676 691676 Colbrond, John, of Borham, gent 0
4974832 2349443 2349443 defendant Colbrond John gent 691676 691676 Colbrond, John, of Borham, gent 0
4974834 2349444 2349444 defendant Colbrond John gent 691676 691676 Colbrond, John, of Borham, gent 0
4987231 2353129 2353129 defendant atte Mill Robert husbandman 691676 691676 atte Mill, Robert, of Borham, husbandman 0
4999652 2356773 2356773 defendant Mell Richard husbandman 691676 691676 Mell, Richard, of Borham, husbandman 0
5014189 2361001 2361001 defendant Wynchestre Henry yeoman 691676 691676 Wynchestre, Henry, of Borham, yeoman 0
5014197 2361002 2361002 defendant Wynchester Thomas smith 691676 691676 Wynchester, Thomas, of Borham, smith 2
5014369 2361063 2361063 defendant atte Mille Richard (legal representative) 691676 691676 atte Mille, Richard, of Borham, executors of 0
5023552 2363798 2363798 defendant Reynold John tailor 691676 691676 Reynold, John, of Borham, tailor 0
5023556 2363799 2363799 defendant Reynold John tailor 691676 691676 Reynold, John, of Borham, tailor 0
5063120 2375505 2375505 defendant Leveryk William husbandman 691676 691676 Leveryk, William, of Borham, husbandman 1
5155808 2402863 2402863 defendant Lampham John, sen husbandman 691676 691676 Lampham, John, sen, of Borham, husbandman 0
5172289 2407619 2407619 defendant Lampham John husbandman 691676 691676 Lampham, John, of Borham, husbandman 0
5212207 2419309 2419309 plaintiff atte Mylle Robert yeoman 691676 691676 atte Mylle, Robert, of Borham, yeoman 0
5218749 2421210 2421210 defendant Alrede Agnes widow 691676 691676 (Alrede, Agnes, of Borham, widow 1
5392208 2472859 2472859 defendant Herde Thomas husbandman 691676 691676 Herde, Thomas, of Borham, husbandman 0
5412493 2478683 2478683 defendant Fritton John husbandman 691676 691676 Fritton, John, of Borham, husbandman 0
5412494 2478683 2478683 defendant Durant Helen widow & formerly wife of John Durant 691676 691676 Durant, Helen, of Borham, widow & formerly wife of John Durant 1
5503690 2506068 2506068 defendant Lole Richard butcher 691676 691676 Lole, Richard, of Borham, butcher 0
5514052 2509246 2509246 plaintiff Power William   691676 691676 Power, William, of Borham 0
5573932 2526940 2526940 defendant John Hugh clerk 691676 691676 John, Hugh, of Borham, clerk 1
5612138 2547531 2547531 defendant Rumbold William   691676 691676 Rumbold, William, of Borham 0
5623036 2551140 2551140 defendant Wilsham Robert   691676 691676 Wilsham, Robert, of Borham 0
5628632 2552924 2552924 defendant Clovyere Nicholas carpenter 691676 691676 Clovyere, Nicholas, of Borham, carpenter 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);