names

52 rows where place_id = 594954

✎ 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
3618257 1873334 1873334 defendant Tempull Edmund husbandman 594954 594954 Tempull, Edmund, of Haddenham, husbandman 0
3641421 1907772 1907772 defendant Marten Richard husbandman 594954 594954 Marten, Richard, of Haddenham, husbandman 1
3683291 1920897 1920897 defendant Barnard Richard   594954 594954 Barnard, Richard, of Haddenham, husbandman, son of Barnard, William 0
3683292 1920897 1920897 defendant Fryday William husbandman 594954 594954 Fryday, William, of Haddenham, husbandman 1
3683293 1920897 1920897 defendant Fryday Richard husbandman 594954 594954 Fryday, Richard, of Haddenham, husbandman 2
3720484 1932690 1932690 defendant Barnard William husbandman 594954 594954 Barnard, William, of Haddenham, husbandman 0
3918641 1996560 1996560 plaintiff Huntley Henry merchant 594954 594954 Huntley, Henry, of Haddenham, merchant 0
3918642 1996560 1996560 defendant Bennett John husbandman 594954 594954 Bennett, John, of Haddenham, husbandman 0
3957462 2009673 2009673 defendant Shrympton William yeoman 594954 594954 Shrympton, William, of Haddenham, yeoman 0
4133455 2072292 2072292 defendant Phips Thomas husbandman 594954 594954 Phips, Thomas, of Haddenham, husbandman 1
4266920 2118580 2118580 defendant Papper Henry husbandman 594954 594954 Papper, Henry, of Haddenham, husbandman 1
4266921 2118580 2118580 defendant Taylor John laborer 594954 594954 Taylor, John, of Haddenham, laborer 2
4266922 2118580 2118580 defendant Coltman Anthony tailor 594954 594954 Coltman, Anthony, of Haddenham, tailor 3
4286880 2125364 2125364 defendant Papper Henry husbandman 594954 594954 Papper, Henry, of Haddenham, husbandman 1
4286881 2125364 2125364 defendant Tayler John laborer 594954 594954 Tayler, John, of Haddenham, laborer 2
4286882 2125364 2125364 defendant Coleman Anthony tailor 594954 594954 Coleman, Anthony, of Haddenham, tailor 3
4307996 2132941 2132941 defendant Barnes Lawrence   594954 594954 Barnes, Lawrence, of Haddenham, Cams, bricklayer, freemason 0
4336173 2142383 2142383 defendant Savadge William, junior husbandman 594954 594954 Savadge, William, junior, of Haddenham, husbandman 0
4336174 2142383 2142383 defendant Barnes Lawrence bricklayer 594954 594954 Barnes, Lawrence, of Haddenham, bricklayer 1
4346107 2145893 2145893 defendant Savage William yeoman 594954 594954 Savage, William, of Haddenham, yeoman 0
4370132 2154378 2154378 defendant Crosse Thomas yeoman 594954 594954 Crosse, Thomas, of Haddenham, yeoman 1
4397589 2163771 2163771 defendant Savage William yeoman 594954 594954 Savage, William, of Haddenham, yeoman 0
4452463 2185766 2185766 defendant Wyghtam William   594954 594954 Wyghtam, William, of Haddenham 1
4644551 2244499 2244499 plaintiff Man William   594954 594954 Man, William, of Haddenham 0
4644553 2244500 2244500 plaintiff Man William   594954 594954 Man, William, of Haddenham 0
4774700 2288076 2288076 defendant Gosselyn John   594954 594954 Gosselyn, John, of Haddenham 1
4818758 2301954 2301954 defendant Mersshe John husbandman 594954 594954 Mersshe, John, of Haddenham, husbandman 3
4824836 2303805 2303805 defendant Roald Robert husbandman 594954 594954 Roald, Robert, of Haddenham, husbandman 1
4824837 2303805 2303805 defendant Harrys John husbandman 594954 594954 Harrys, John, of Haddenham, husbandman 2
4840936 2308699 2308699 defendant Scolas Thomas husbandman 594954 594954 Scolas, Thomas, of Haddenham, husbandman 0
4874337 2318917 2318917 defendant Stevene John husbandman 594954 594954 Stevene, John, of Haddenham, husbandman 0
4897223 2325787 2325787 defendant Tirrell Thomas butcher 594954 594954 Tirrell, Thomas, of Haddenham, butcher 2
4934700 2337246 2337246 defendant Scolas Thomas butcher 594954 594954 Scolas, Thomas, of Haddenham, butcher 0
4939182 2338642 2338642 defendant Bryne Thomas laborer 594954 594954 Bryne, Thomas, of Haddenham, laborer 1
4998224 2356337 2356337 defendant Colyns John gent 594954 594954 Colyns, John, of Haddenham, gent 0
5001635 2357370 2357370 defendant Broun Thomas butcher 594954 594954 Broun, Thomas, of Haddenham, butcher 0
5001636 2357370 2357370 defendant Ruley John tailor 594954 594954 Ruley, John, of Haddenham, tailor 1
5038309 2368098 2368098 defendant Wodebrigge William butcher 594954 594954 Wodebrigge, William, of Haddenham, butcher 3
5047698 2370929 2370929 defendant Pesfeld Richard husbandman 594954 594954 Pesfeld, Richard, of Haddenham, husbandman 3
5143973 2399382 2399382 defendant Chapman William husbandman 594954 594954 Chapman, William, of Haddenham, husbandman 0
5314227 2449269 2449269 defendant Wyllys John yeoman 594954 594954 Wyllys, John, of Haddenham, yeoman 0
5315355 2449649 2449649 defendant James Thomas (legal representative) 594954 594954 James, Thomas, of Haddenham, yeoman, executors of 0
5315356 2449649 2449649 defendant Atkyn John yeoman 594954 594954 (Atkyn, John, of Haddenham, yeoman 1
5320339 2451171 2451171 plaintiff Jamys alias Grene Thomas (legal representative) 594954 594954 Jamys alias Grene, Thomas, of Haddenham, butcher, executors of 0
5397820 2474446 2474446 defendant Bernard John, junior   594954 594954 Bernard, John, junior, of Haddenham, 0
5399426 2474912 2474912 defendant Wyndonte John husbandman 594954 594954 Wyndonte, John, of Haddenham, husbandman 0
5417151 2480037 2480037 defendant B_ John husbandman 594954 594954 B_, John, of Haddenham, husbandman 0
5421369 2481322 2481322 defendant Welys John husbandman 594954 594954 Welys, John, of Haddenham, husbandman 1
5434317 2485201 2485201 defendant Barnard John husbandman 594954 594954 Barnard, John, of Haddenham, husbandman 0
5501717 2505469 2505469 defendant Pymme Henry cordwainer 594954 594954 Pymme, Henry, of Haddenham, cordwainer 1
5625513 2551923 2551923 defendant Grene James yeoman 594954 594954 Grene, James, of Haddenham, yeoman 1
5625514 2551923 2551923 defendant Grene John yeoman 594954 594954 Grene, John, of Haddenham, yeoman 2

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);