names

55 rows where place_id = 594945

✎ 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
3618225 1873324 1873324 defendant Lemman Thomas bargeman 594945 594945 Lemman, Thomas, of Walton on Thames, bargeman 0
3642350 1908054 1908054 defendant Attwod John butcher 594945 594945 Attwod, John, of Walton on Thames, butcher 0
3675401 1918344 1918344 defendant Heward Robert baker 594945 594945 Heward, Robert, of Walton on Thames, baker 0
3675406 1918344 1918344 defendant Nortiche William fisherman 594945 594945 Nortiche, William, of Walton on Thames, fisherman 5
3677264 1918937 1918937 defendant Saman John husbandman 594945 594945 Saman, John, of Walton on Thames, husbandman 0
3752944 1942850 1942850 defendant Hardwen John husbandman 594945 594945 Hardwen, John, of Walton on Thames, husbandman 0
3778043 1950847 1950847 defendant Hycher Robert butcher 594945 594945 Hycher, Robert, of Walton on Thames, butcher 0
3778045 1950847 1950847 defendant Bartlott Thomas husbandman 594945 594945 Bartlott, Thomas, of Walton on Thames, husbandman 2
3787030 1953739 1953739 defendant Hyther Robert butcher 594945 594945 Hyther, Robert, of Walton on Thames, butcher 0
3787031 1953739 1953739 defendant Wallys Henry husbandman 594945 594945 Wallys, Henry, of Walton on Thames, husbandman 1
3812144 1961710 1961710 defendant Broun William tailor 594945 594945 Broun, William, of Walton on Thames, tailor 1
3817867 1963504 1963504 defendant Perce Alan clerk 594945 594945 Perce, Alan, of Walton on Thames, clerk 0
3876757 1982468 1982468 defendant Lye John husbandman 594945 594945 Lye, John, of Walton on Thames, husbandman 2
3898182 1989598 1989598 defendant Braydelley John laborer 594945 594945 Braydelley, John, of Walton on Thames, laborer 1
3898183 1989598 1989598 defendant Bysseck John laborer 594945 594945 Bysseck, John, of Walton on Thames, laborer 2
4035007 2037203 2037203 plaintiff Helhowse alias Ellys Robert bargeman 594945 594945 Helhowse alias Ellys, Robert, of Walton on Thames, bargeman 0
4169743 2084908 2084908 defendant Thorne Thomas gent 594945 594945 Thorne, Thomas, of Walton on Thames, gent 0
4223474 2103700 2103700 plaintiff Yonge John yeoman 594945 594945 Yonge, John, of Walton on Thames, yeoman 0
4233449 2107214 2107214 defendant Woolmer Thomas baker 594945 594945 Woolmer, Thomas, of Walton on Thames, baker 0
4233450 2107214 2107214 defendant Wood James husbandman 594945 594945 Wood, James, of Walton on Thames, husbandman 1
4691022 2262717 2262717 plaintiff Woodlyoke Henry   594945 594945 Woodlyoke, Henry, of Walton on Thames 0
4928465 2335326 2335326 defendant Doghill Robert, junior husbandman 594945 594945 Doghill, Robert, junior, of Walton on Thames, husbandman 0
4934248 2337100 2337100 defendant Teme Robert husbandman 594945 594945 Teme, Robert, of Walton on Thames, husbandman 1
4934250 2337100 2337100 defendant Dogell Richard husbandman 594945 594945 Dogell, Richard, of Walton on Thames, husbandman 3
4956189 2343815 2343815 defendant Dogell Richard husbandman 594945 594945 Dogell, Richard, of Walton on Thames, husbandman 0
5039608 2368494 2368494 defendant Foxe William clerk 594945 594945 Foxe, William, of Walton on Thames, clerk 0
5143705 2399290 2399290 defendant Wethyr Thomas husbandman 594945 594945 Wethyr, Thomas, of Walton on Thames, husbandman 0
5163817 2405153 2405153 defendant Wether Thomas husbandman 594945 594945 Wether, Thomas, of Walton on Thames, husbandman 0
5167959 2406338 2406338 defendant Dogell Richard husbandman 594945 594945 Dogell, Richard, of Walton on Thames, husbandman 2
5177315 2409060 2409060 defendant Wether Thomas husbandman 594945 594945 Wether, Thomas, of Walton on Thames, husbandman 0
5178323 2409365 2409365 defendant Wethyr Thomas husbandman 594945 594945 Wethyr, Thomas, of Walton on Thames, husbandman 0
5178325 2409366 2409366 defendant Wethyr Thomas husbandman 594945 594945 Wethyr, Thomas, of Walton on Thames, husbandman 0
5178500 2409422 2409422 defendant Haukyn William husbandman 594945 594945 Haukyn, William, of Walton on Thames, husbandman 0
5181972 2410476 2410476 defendant Dogell Richard husbandman 594945 594945 Dogell, Richard, of Walton on Thames, husbandman 0
5181973 2410476 2410476 defendant Wether Richard husbandman 594945 594945 Wether, Richard, of Walton on Thames, husbandman 1
5181974 2410476 2410476 defendant Wether Thomas husbandman 594945 594945 Wether, Thomas, of Walton on Thames, husbandman 2
5183668 2410956 2410956 defendant Quale John husbandman 594945 594945 Quale, John, of Walton on Thames, husbandman 0
5188631 2412397 2412397 defendant Wether Thomas husbandman 594945 594945 Wether, Thomas, of Walton on Thames, husbandman 0
5200281 2415842 2415842 defendant Wether Thomas husbandman 594945 594945 Wether, Thomas, of Walton on Thames, husbandman 0
5200283 2415843 2415843 defendant Wethyr Thomas husbandman 594945 594945 Wethyr, Thomas, of Walton on Thames, husbandman 0
5201405 2416167 2416167 defendant Wether Thomas husbandman 594945 594945 Wether, Thomas, of Walton on Thames, husbandman 0
5203160 2416686 2416686 defendant Dogell William husbandman 594945 594945 Dogell, William, of Walton on Thames, husbandman 0
5203161 2416686 2416686 defendant Wether Richard husbandman 594945 594945 Wether, Richard, of Walton on Thames, husbandman 1
5203162 2416686 2416686 defendant Wether Thomas husbandman 594945 594945 Wether, Thomas, of Walton on Thames, husbandman 2
5203954 2416905 2416905 defendant Dogell Richard husbandman 594945 594945 Dogell, Richard, of Walton on Thames, husbandman 1
5211439 2419079 2419079 defendant Wether Thomas husbandman 594945 594945 Wether, Thomas, of Walton on Thames, husbandman 0
5297534 2444286 2444286 defendant Forster Simon butcher 594945 594945 Forster, Simon, of Walton on Thames, butcher 0
5321127 2451417 2451417 defendant Halle William husbandman 594945 594945 Halle, William, of Walton on Thames, husbandman 0
5452229 2490542 2490542 defendant Croxton John clerk 594945 594945 Croxton, John, of Walton on Thames, clerk 0
5543869 2518192 2518192 defendant Heth John yeoman 594945 594945 Heth, John, of Walton on Thames, yeoman 0
5548817 2519698 2519698 defendant Amore John husbandman 594945 594945 Amore, John, of Walton on Thames, husbandman 0
5556109 2521782 2521782 defendant Berys John husbandman 594945 594945 Berys, John, of Walton on Thames, husbandman 0
5562750 2523691 2523691 defendant Wodclerke John husbandman 594945 594945 Wodclerke, John, of Walton on Thames, husbandman 0
5569324 2525586 2525586 defendant Styffe William waterman 594945 594945 Styffe, William, of Walton on Thames, waterman 2
5626051 2552110 2552110 defendant Breche Thomas husbandman 594945 594945 Breche, Thomas, of Walton on Thames, husbandman 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);