names

58 rows where place_id = 587250

✎ 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
3590909 1864784 1864784 defendant Stoneham Thomas clerk 587250 587250 Stoneham, Thomas, of Coryngham, clerk 1
3630629 1904408 1904408 defendant Thurston Richard butcher 587250 587250 Thurston, Richard, of Coryngham, butcher 0
3631087 1904548 1904548 defendant Munde William husbandman 587250 587250 Munde, William, of Coryngham, husbandman 1
3711438 1929883 1929883 defendant Blawe Thomas husbandman 587250 587250 Blawe, Thomas, of Coryngham, husbandman 0
3720681 1932758 1932758 defendant Adams John husbandman 587250 587250 Adams, John, of Coryngham, husbandman 0
3865709 1978753 1978753 defendant Rogers William husbandman 587250 587250 Rogers, William, of Coryngham, husbandman 0
4048157 2041777 2041777 defendant Willson Alexander yeoman 587250 587250 Willson, Alexander, of Coryngham, yeoman 1
4465175 2189769 2189769 plaintiff Williamson John clerk 587250 587250 Williamson, John, of Coryngham, clerk 0
4465176 2189769 2189769 defendant Clyfland John de   587250 587250 Clyfland, John de, of Coryngham 0
4470242 2191340 2191340 defendant Duke Jamde   587250 587250 Duke, Jamde, of Coryngham 0
4471942 2191890 2191890 defendant Maulyn John   587250 587250 Maulyn, John, of Coryngham, parson 0
4473760 2192438 2192438 defendant Hayles William   587250 587250 Hayles, William, of Coryngham 1
4473761 2192438 2192438 defendant Milner William   587250 587250 Milner, William, of Coryngham 2
4473762 2192438 2192438 defendant Skynner Richard   587250 587250 Skynner, Richard, of Coryngham 3
4499975 2200632 2200632 defendant duffeld Richard   587250 587250 duffeld, Richard, of Coryngham 2
4524345 2207951 2207951 defendant Duffeld Richard   587250 587250 Duffeld, Richard, of Coryngham 0
4538301 2212268 2212268 defendant Broke Henry   587250 587250 Broke, Henry, of Coryngham 0
4569784 2222126 2222126 defendant Wylyngham Thomas   587250 587250 Wylyngham, Thomas, of Coryngham 10
4571134 2222541 2222541 defendant Willyngham Thomas de   587250 587250 Willyngham, Thomas de, of Coryngham 0
4571136 2222542 2222542 defendant Willyngham Thomas   587250 587250 Willyngham, Thomas, of Coryngham 0
4572779 2223023 2223023 defendant Webbe Roger   587250 587250 Webbe, Roger, of Coryngham 3
4669756 2256242 2256242 defendant Isabell Thomas yeoman 587250 587250 Isabell, Thomas, of Coryngham, yeoman 0
4702284 2266123 2266123 defendant Cosyn John husbandman 587250 587250 Cosyn, John, of Coryngham, husbandman 0
4702285 2266123 2266123 defendant Brook Thomas laborer 587250 587250 Brook, Thomas, of Coryngham, laborer 1
4702795 2266274 2266274 defendant Couper John laborer 587250 587250 Couper, John, of Coryngham, laborer 0
4719974 2271593 2271593 defendant Treweman William butcher 587250 587250 Treweman, William, of Coryngham, butcher 0
4722821 2272451 2272451 defendant Godfray Robert (legal representative) 587250 587250 Godfray, Robert, of Coryngham, executors of 2
4722822 2272451 2272451 defendant Godfray Joan   587250 587250 (Godfray, Joan, of Coryngham, widow, formerly wife of Robert 3
4741752 2278082 2278082 defendant Paule Richard smith 587250 587250 Paule, Richard, of Coryngham, smith 1
4775101 2288206 2288206 defendant Piers John husbandman 587250 587250 Piers, John, of Coryngham, husbandman 0
4784024 2291013 2291013 defendant Darnall Thomas gent 587250 587250 Darnall, Thomas, of Coryngham, gent 0
4784027 2291013 2291013 defendant Andrewe William husbandman 587250 587250 Andrewe, William, of Coryngham, husbandman 3
4784028 2291013 2291013 defendant Colby William husbandman 587250 587250 Colby, William, of Coryngham, husbandman 4
4784029 2291013 2291013 defendant Charp Richard husbandman 587250 587250 Charp, Richard, of Coryngham, husbandman 5
4895546 2325275 2325275 defendant Bercotes Roger husbandman 587250 587250 Bercotes, Roger, of Coryngham, husbandman 0
5039151 2368354 2368354 plaintiff Breyve Roger   587250 587250 Breyve, Roger, of Coryngham, parson 4
5039161 2368355 2368355 plaintiff Greyve Roger   587250 587250 Greyve, Roger, of Coryngham, parson 4
5106994 2388474 2388474 plaintiff de Layn Stephen   587250 587250 de Layn, Stephen, of Coryngham 0
5124121 2393512 2393512 defendant atte Lee Thomas yeoman 587250 587250 atte Lee, Thomas, of Coryngham, yeoman 0
5200725 2415967 2415967 defendant atte Lee Thomas yeoman 587250 587250 atte Lee, Thomas, of Coryngham, yeoman 0
5200727 2415968 2415968 defendant atte Lee Thomas yeoman 587250 587250 atte Lee, Thomas, of Coryngham, yeoman 0
5211599 2419129 2419129 defendant atte Lee Thomas yeoman 587250 587250 atte Lee, Thomas, of Coryngham, yeoman 0
5211601 2419130 2419130 defendant atte Lee Thomas yeoman 587250 587250 atte Lee, Thomas, of Coryngham, yeoman 0
5229304 2424181 2424181 defendant atte Lee Thomas yeoman 587250 587250 atte Lee, Thomas, of Coryngham, yeoman 0
5229306 2424182 2424182 defendant Attlee Thomas yeoman 587250 587250 Attlee, Thomas, of Coryngham, yeoman 0
5334828 2455486 2455486 defendant Rogers John husbandman 587250 587250 Rogers, John, of Coryngham, husbandman 0
5334830 2455486 2455486 defendant Barbour Richard husbandman 587250 587250 Barbour, Richard, of Coryngham, husbandman 2
5364228 2464470 2464470 defendant Samer William husbandman 587250 587250 Samer, William, of Coryngham, husbandman 0
5461223 2493304 2493304 defendant Poole Robert yeoman 587250 587250 Poole Robert, of Coryngham, yeoman 4
5465435 2494571 2494571 defendant Belknap Thomas husbandman 587250 587250 Belknap, Thomas, of Coryngham, husbandman 0
5472756 2496818 2496818 defendant Poole Robert yeoman 587250 587250 Poole, Robert, of Coryngham, yeoman 4
5472766 2496821 2496821 defendant Pool Robert yeoman 587250 587250 Pool, Robert, of Coryngham, yeoman 4
5472772 2496822 2496822 defendant Poole Robert yeoman 587250 587250 Poole, Robert, of Coryngham, yeoman 4
5484360 2500242 2500242 defendant Poole Robert yeoman 587250 587250 Poole, Robert, of Coryngham, yeoman 4
5496582 2503892 2503892 defendant Austyn William   587250 587250 Austyn, William, of Coryngham 0
5578228 2528262 2528262 defendant Clerk John husbandman 587250 587250 Clerk, John, of Coryngham, husbandman 1
5626065 2552114 2552114 defendant Treweman William butcher 587250 587250 Treweman, William, of Coryngham, butcher 1
5631475 2553853 2553853 plaintiff Smyth Roger   587250 587250 Smyth, Roger, of Coryngham 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);