names

82 rows where place_id = 753819

✎ 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
4415955 2169876 2169876 defendant Palmere Michael le   753819 753819 Palmere, Michael le, of Great Waltham 0
4486981 2196646 2196646 defendant Berwyk Thomas   753819 753819 Berwyk, Thomas, of Great Waltham 0
4548602 2215503 2215503 plaintiff Clerk Humphrey   753819 753819 Clerk, Humphrey, of Great Waltham 0
4551174 2216309 2216309 plaintiff Drake John   753819 753819 Drake, John, of Great Waltham 0
4551176 2216310 2216310 plaintiff Drake John   753819 753819 Drake, John, of Great Waltham 0
4557872 2218393 2218393 defendant atte Hyd Thomas   753819 753819 atte Hyd, Thomas, of Great Waltham 0
4583431 2226237 2226237 plaintiff Fray John   753819 753819 Fray, John, of Great Waltham 0
4601828 2231793 2231793 defendant Bred John   753819 753819 Bred, John, of Great Waltham 0
4609016 2233921 2233921 defendant Hyde Thomas   753819 753819 Hyde, Thomas, of Great Waltham 1
4612164 2234870 2234870 defendant Bletche William, sen   753819 753819 Bletche, William, sen, of Great Waltham 0
4639034 2242933 2242933 plaintiff Clerk Humphrey   753819 753819 Clerk, Humphrey, of Great Waltham 0
4671698 2256794 2256794 defendant Swetyng John husbandman 753819 753819 Swetyng, John, of Great Waltham, husbandman 2
4689807 2262373 2262373 defendant Peverell John husbandman 753819 753819 Peverell, John, of Great Waltham, husbandman 0
4697413 2264678 2264678 plaintiff Cok John   753819 753819 Cok, John, of Great Waltham 0
4700572 2265589 2265589 defendant atte More Thomas husbandman 753819 753819 atte More, Thomas, of Great Waltham, husbandman 0
4700573 2265589 2265589 defendant Badyngham John tailor 753819 753819 Badyngham, John, of Great Waltham, tailor 1
4712905 2269349 2269349 defendant Litle John yeoman 753819 753819 Litle, John, of Great Waltham, yeoman 1
4712906 2269349 2269349 defendant Bred Richard yeoman 753819 753819 Bred, Richard, of Great Waltham, yeoman 2
4712907 2269349 2269349 defendant Startelgh Andrew yeoman 753819 753819 Startelgh, Andrew, of Great Waltham, yeoman 3
4715497 2270183 2270183 defendant atte Hide Thomas husbandman 753819 753819 atte Hide, Thomas, of Great Waltham, husbandman 0
4715500 2270183 2270183 defendant Drake William husbandman 753819 753819 Drake, William, of Great Waltham, husbandman 3
4725781 2273351 2273351 defendant Sayer John husbandman 753819 753819 Sayer, John, of Great Waltham, husbandman 2
4725782 2273351 2273351 defendant Leftchilde John husbandman 753819 753819 Leftchilde, John, of Great Waltham, husbandman 3
4732118 2275228 2275228 defendant Child John husbandman 753819 753819 Child, John, of Great Waltham, husbandman 0
4734920 2276080 2276080 defendant Cok John husbandman 753819 753819 Cok, John, of Great Waltham, husbandman 3
4740114 2277625 2277625 defendant Lye William yeoman 753819 753819 Lye, William, of Great Waltham, yeoman 0
4754494 2281785 2281785 defendant Drake John husbandman 753819 753819 Drake, John, of Great Waltham, husbandman 0
4756619 2282435 2282435 plaintiff Bernard John   753819 753819 Bernard, John, of Great Waltham 0
4766464 2285503 2285503 defendant Sandre John husbandman 753819 753819 Sandre, John, of Great Waltham, husbandman 0
4772515 2287368 2287368 defendant atte Nasshe Thomas husbandman 753819 753819 atte Nasshe, Thomas, of Great Waltham, husbandman 0
4804783 2297696 2297696 defendant Bernard John   753819 753819 Bernard, John, of Great Waltham, parish clerk 0
4804784 2297696 2297696 defendant Badcok John tailor 753819 753819 Badcok, John, of Great Waltham, tailor 1
4811446 2299691 2299691 defendant Harewakyr William fuller 753819 753819 Harewakyr, William, of Great Waltham, fuller 1
4848888 2311119 2311119 plaintiff Smyth John (legal representative) 753819 753819 Smyth, John, of Great Waltham, executors of 0
4853500 2312505 2312505 plaintiff Wolston John   753819 753819 Wolston, John, of Great Waltham 0
4912742 2330489 2330489 defendant Meller Geoffrey miller 753819 753819 Meller, Geoffrey, of Great Waltham, miller 0
4922265 2333378 2333378 defendant Warde Thomas latmaker or lathe maker 753819 753819 Warde, Thomas, of Great Waltham, latmaker or lathe maker 0
4925756 2334491 2334491 defendant Grene alias Fooche Thomas tailor 753819 753819 Grene alias Fooche, Thomas, of Great Waltham, tailor 0
4926821 2334813 2334813 defendant Waraunger John yeoman 753819 753819 Waraunger, John, of Great Waltham, yeoman 1
4994177 2355133 2355133 defendant Cornyssh Thomas yeoman 753819 753819 Cornyssh, Thomas, of Great Waltham, yeoman 1
4999991 2356878 2356878 defendant Blacche John husbandman 753819 753819 Blacche, John, of Great Waltham, husbandman 0
5039245 2368379 2368379 plaintiff Drakys Thomas   753819 753819 Drakys, Thomas, of Great Waltham 1
5132730 2396068 2396068 defendant Glastok John (legal representative) 753819 753819 Glastok, John, of Great Waltham, executrix of 0
5270447 2436457 2436457 defendant Glascok Robert yeoman 753819 753819 Glascok, Robert, of Great Waltham, yeoman 0
5297760 2444349 2444349 defendant Tanner John husbandman 753819 753819 Tanner, John, of Great Waltham, husbandman Tanner, John, of Felsted, husbandman 0
5300172 2445014 2445014 defendant Harrys Nicholas husbandman 753819 753819 Harrys, Nicholas, of Great Waltham, husbandman 0
5300775 2445193 2445193 defendant Brygge Richard husbandman 753819 753819 Brygge, Richard, of Great Waltham, husbandman 1
5306155 2446831 2446831 defendant Devenych Robert husbandman 753819 753819 Devenych, Robert, of Great Waltham, husbandman 1
5373035 2467157 2467157 defendant Harrise Nicholas husbandman 753819 753819 Harrise, Nicholas, of Great Waltham, husbandman 0
5373037 2467157 2467157 defendant Pynchon Robert butcher 753819 753819 Pynchon, Robert, of Great Waltham, butcher 2
5378898 2468988 2468988 defendant Denaunt or Devaunt John tanner 753819 753819 Denaunt or Devaunt, John, of Great Waltham, tanner 0
5380666 2469517 2469517 defendant Blastok William yeoman 753819 753819 Blastok, William, of Great Waltham, yeoman 1
5383338 2470312 2470312 defendant Glastok William   753819 753819 Glastok, William, of Great Waltham 1
5391781 2472724 2472724 defendant Fawese Thomas butcher 753819 753819 Fawese, Thomas, of Great Waltham, butcher 1
5393991 2473339 2473339 defendant Wodeham Thomas yeoman 753819 753819 Wodeham, Thomas, of Great Waltham, yeoman 0
5400399 2475187 2475187 defendant Harrys Nicholas husbandman 753819 753819 Harrys, Nicholas, of Great Waltham, husbandman 0
5400400 2475187 2475187 defendant Freman William husbandman 753819 753819 Freman, William, of Great Waltham, husbandman 1
5402896 2475910 2475910 defendant Wodam Thomas yeoman 753819 753819 Wodam, Thomas, of Great Waltham, yeoman 0
5402900 2475910 2475910 defendant Stabylle John laborer 753819 753819 Stabylle, John, of Great Waltham, laborer 4
5415850 2479676 2479676 defendant Wodam Thomas yeoman 753819 753819 Wodam, Thomas, of Great Waltham, yeoman 0
5415853 2479676 2479676 defendant Pynchon Robert butcher 753819 753819 Pynchon, Robert, of Great Waltham, butcher 3
5415854 2479676 2479676 defendant Stabille John laborer 753819 753819 Stabille, John, of Great Waltham, laborer 4
5415862 2479678 2479678 defendant Harrys Nicholas husbandman 753819 753819 Harrys, Nicholas, of Great Waltham, husbandman 0
5415863 2479678 2479678 defendant Freman William husbandman 753819 753819 Freman, William, of Great Waltham, husbandman 1
5428684 2483494 2483494 defendant Wodeham Thomas yeoman 753819 753819 Wodeham, Thomas, of Great Waltham, yeoman 0
5430041 2483918 2483918 defendant Blastok William yeoman 753819 753819 Blastok, William, of Great Waltham, yeoman 1
5439117 2486623 2486623 defendant Wodeham Thomas yeoman 753819 753819 Wodeham, Thomas, of Great Waltham, yeoman 3
5439724 2486821 2486821 plaintiff Wayte Thomas gent 753819 753819 Wayte, Thomas, of Great Waltham, gent 0
5439726 2486822 2486822 plaintiff Wayte Thomas gent 753819 753819 Wayte, Thomas, of Great Waltham, gent 0
5439728 2486823 2486823 plaintiff Wayte Thomas gent 753819 753819 Wayte, Thomas, of Great Waltham, gent 0
5448526 2489456 2489456 defendant Wodham Thomas yeoman 753819 753819 Wodham, Thomas, of Great Waltham, yeoman 0
5452984 2490772 2490772 defendant Wodeham Thomas   753819 753819 Wodeham, Thomas, of Great Waltham 2
5453386 2490901 2490901 plaintiff Wayte Thomas gent 753819 753819 Wayte, Thomas, of Great Waltham, gent 0
5453388 2490902 2490902 plaintiff Wayte Thomas gent 753819 753819 Wayte, Thomas, of Great Waltham, gent 0
5460919 2493216 2493216 defendant Manore John gent 753819 753819 Manore, John, of Great Waltham, gent 0
5464936 2494425 2494425 defendant Wodeham Thomas   753819 753819 Wodeham, Thomas, of Great Waltham 2
5464942 2494426 2494426 defendant Wodeham Thomas yeoman 753819 753819 Wodeham, Thomas, of Great Waltham, yeoman 2
5472514 2496745 2496745 defendant Manore John gent 753819 753819 Manore, John, of Great Waltham, gent 0
5476803 2498064 2498064 plaintiff Wayte Thomas gent 753819 753819 Wayte, Thomas, of Great Waltham, gent 0
5620501 2550272 2550272 plaintiff Sawene James   753819 753819 Sawene, James, of Great Waltham 0
5620504 2550273 2550273 plaintiff Sawene James   753819 753819 Sawene, James, of Great Waltham 0
5620506 2550274 2550274 plaintiff Sawene James   753819 753819 Sawene, James, of Great Waltham 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);