names

105 rows where place_id = 590847

✎ 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
3602490 1868439 1868439 defendant Trentyll Thomas yeoman 590847 590847 Trentyll, Thomas, of Saham, yeoman 4
3635191 1905801 1905801 defendant Butler Thomas clerk 590847 590847 Butler, Thomas, of Saham, clerk 2
3674356 1918024 1918024 plaintiff Turnor Joan widow 590847 590847 Turnor, Joan, of Saham, widow 1
3688738 1922640 1922640 defendant Chapman Katherine   590847 590847 Chapman, Katherine, of Saham Tony, spinster, daughter of Chapman, John 0
3707566 1928660 1928660 defendant Parett George husbandman 590847 590847 Parett, George, of Saham, husbandman 5
3732203 1936309 1936309 defendant Yelverton John gent 590847 590847 Yelverton, John, of Saham, gent 0
3734186 1936933 1936933 defendant Yelverton John gent 590847 590847 Yelverton, John, of Saham, gent 0
3771050 1948633 1948633 defendant Yelverton John gent 590847 590847 Yelverton, John, of Saham, gent 0
3824859 1965655 1965655 defendant Markaunt Robert beer brewer 590847 590847 Markaunt, Robert, of Saham, beer brewer 0
3837648 1969684 1969684 defendant Awston Thomas husbandman 590847 590847 Awston, Thomas, of Saham, husbandman 0
3892374 1987701 1987701 plaintiff Mordey John, senior   590847 590847 Mordey, John, senior, of Saham 0
3933476 2001481 2001481 plaintiff Gryffyn John (legal representative) 590847 590847 Gryffyn, John, of Saham, executors of 0
3994334 2022726 2022726 plaintiff Cocke Joan widow 590847 590847 Cocke, Joan, of Saham, widow 0
4080673 2053400 2053400 plaintiff Watson William   590847 590847 Watson, William, of Saham 0
4088912 2056339 2056339 defendant Jakes William husbandman 590847 590847 Jakes, William, of Saham, husbandman 0
4090104 2056745 2056745 defendant Clarke William chapman 590847 590847 Clarke, William, of Saham, chapman 2
4424088 2172388 2172388 plaintiff Hog Roger   590847 590847 Hog, Roger, of Saham 0
4424090 2172389 2172389 plaintiff Hog Roger   590847 590847 Hog, Roger, of Saham 0
4424094 2172391 2172391 plaintiff Hogg Roger   590847 590847 Hogg, Roger, of Saham 0
4495345 2199224 2199224 defendant Wilkyn John   590847 590847 Wilkyn, John, of Saham 0
4501878 2201187 2201187 defendant Freman Alexander   590847 590847 Freman, Alexander, of Saham 5
4502231 2201296 2201296 plaintiff Merkaunt Richard   590847 590847 Merkaunt, Richard, of Saham, on his own account 0
4510741 2203816 2203816 defendant Eustas John   590847 590847 Eustas, John, of Saham 0
4510742 2203816 2203816 defendant Waryner John   590847 590847 Waryner, John, of Saham 1
4525911 2208403 2208403 defendant Skynnere Bartholomew   590847 590847 Skynnere, Bartholomew, of Saham 2
4526259 2208500 2208500 defendant Rokel John   590847 590847 Rokel, John, of Saham 3
4533615 2210781 2210781 defendant Sket John clerk 590847 590847 Sket, John, of Saham, clerk 0
4535471 2211365 2211365 plaintiff Slappe John   590847 590847 Slappe, John, of Saham 0
4547009 2214998 2214998 defendant Bette John smith 590847 590847 Bette, John, of Saham, smith 1
4559485 2218916 2218916 defendant Rokell John   590847 590847 Rokell, John, of Saham 0
4559486 2218916 2218916 defendant Rokell William   590847 590847 Rokell, William, of Saham 1
4576530 2224171 2224171 plaintiff Brydde John   590847 590847 Brydde, John, of Saham 0
4585162 2226780 2226780 defendant Rokel John   590847 590847 Rokel, John, of Saham 0
4586537 2227198 2227198 defendant Ketelberne John   590847 590847 Ketelberne, John, of Saham 1
4621014 2237557 2237557 defendant Neweman John   590847 590847 Neweman, John, of Saham 1
4633304 2241280 2241280 defendant Coke John   590847 590847 Coke, John, of Saham, formerly servant of Thomas Person 0
4641555 2243629 2243629 plaintiff Rokel John   590847 590847 Rokel, John, of Saham 1
4655002 2247446 2247446 defendant Goos Robert yeoman 590847 590847 Goos, Robert, of Saham, yeoman 5
4655009 2247447 2247447 defendant Goos Robert yeoman 590847 590847 Goos, Robert, of Saham, yeoman 5
4663143 2249941 2249941 defendant Wryght Richard husbandman 590847 590847 Wryght, Richard, of Saham, husbandman 0
4663146 2249941 2249941 defendant Stubberd John husbandman 590847 590847 Stubberd, John, of Saham, husbandman 3
4663147 2249942 2249942 plaintiff Gegh Richard (legal representative) 590847 590847 Gegh, Richard, of Saham, executors of 0
4663153 2249942 2249942 defendant Barford William   590847 590847 Barford, William, of Saham, shepherd 1
4667255 2255490 2255490 defendant Rokell John yeoman 590847 590847 Rokell, John, of Saham, yeoman 0
4668506 2255857 2255857 defendant Howard Edward husbandman 590847 590847 Howard, Edward, of Saham, husbandman 0
4683062 2260319 2260319 defendant Fraunceys Thoams husbandman 590847 590847 Fraunceys, Thoams, of Saham, husbandman 0
4691877 2262994 2262994 defendant Brakke Thomas husbandman 590847 590847 Brakke, Thomas, of Saham, husbandman 2
4719237 2271364 2271364 defendant Notyngham Simon husbandman 590847 590847 Notyngham, Simon, of Saham, husbandman 2
4728070 2274026 2274026 plaintiff Howard Edward   590847 590847 Howard, Edward, of Saham 0
4728071 2274026 2274026 defendant Kyme Thomas husbandman 590847 590847 Kyme, Thomas, of Saham, husbandman 0
4728073 2274026 2274026 defendant Rouhed Thomas yeoman 590847 590847 Rouhed, Thomas, of Saham, yeoman 2
4759016 2283170 2283170 defendant Turnay William husbandman 590847 590847 Turnay, William, of Saham, husbandman 2
4759018 2283171 2283171 defendant Turnay William husbandman 590847 590847 Turnay, William, of Saham, husbandman 0
4798300 2295658 2295658 defendant Gegge John (legal representative) 590847 590847 Gegge, John, of Saham, esq, executor of 0
4803687 2297337 2297337 defendant Dunyng Simon husbandman 590847 590847 Dunyng, Simon, of Saham, husbandman 5
4803689 2297337 2297337 defendant Just Thomas laborer 590847 590847 Just, Thomas, of Saham, laborer 7
4804929 2297746 2297746 defendant Derby William husbandman 590847 590847 Derby, William, of Saham, husbandman 0
4811686 2299765 2299765 defendant Hasey John husbandman 590847 590847 Hasey, John, of Saham, husbandman 3
4823812 2303530 2303530 defendant Donyngton John yeoman 590847 590847 Donyngton, John, of Saham, yeoman 1
4825440 2304002 2304002 defendant Thornton William warrener 590847 590847 Thornton, William, of Saham, warrener 0
4829883 2305391 2305391 defendant Smyth Andrew smith 590847 590847 Smyth, Andrew, of Saham, smith 1
4832327 2306143 2306143 defendant Carpenter William husbandman 590847 590847 Carpenter, William, of Saham, husbandman 0
4832328 2306143 2306143 defendant Salesbury John husbandman 590847 590847 Salesbury, John, of Saham, husbandman 1
4872585 2318383 2318383 defendant Smyth Andrew smith 590847 590847 Smyth, Andrew, of Saham, smith 1
4887249 2322850 2322850 defendant Chapman Thomas yeoman 590847 590847 Chapman, Thomas, of Saham, yeoman 2
4889698 2323571 2323571 plaintiff Gegge Richard esq 590847 590847 Gegge, Richard, of Saham, esq 0
4902552 2327416 2327416 defendant Chapman Thomas yeoman 590847 590847 Chapman, Thomas, of Saham, yeoman 2
4989638 2353821 2353821 defendant Faukes Henry   590847 590847 Faukes, Henry, of Saham 0
5003837 2358014 2358014 defendant Derby William husbandman 590847 590847 Derby, William, of Saham, husbandman 1
5003839 2358014 2358014 defendant Smyth John husbandman 590847 590847 Smyth, John, of Saham, husbandman 3
5018544 2362305 2362305 defendant atte Hill John chandler 590847 590847 atte Hill, John, of Saham, chandler 1
5018545 2362305 2362305 defendant Bettys Nicholas husbandman 590847 590847 Bettys, Nicholas, of Saham, husbandman 2
5022208 2363388 2363388 defendant Baxter Richard yeoman 590847 590847 Baxter, Richard, of Saham, yeoman 1
5035339 2367194 2367194 defendant Turveys Thomas yeoman 590847 590847 Turveys, Thomas, of Saham, yeoman 0
5044707 2370052 2370052 plaintiff Couper John   590847 590847 Couper, John, of Saham 1
5072836 2378358 2378358 plaintiff Tonge William   590847 590847 Tonge, William, of Saham 0
5112186 2389947 2389947 plaintiff Howard Richard   590847 590847 Howard, Richard, of Saham 0
5117093 2391425 2391425 defendant Thornton John husbandman 590847 590847 Thornton, John, of Saham, husbandman 5
5125985 2394085 2394085 defendant Snoryng Arnold gent 590847 590847 Snoryng, Arnold, of Saham, gent 1
5144586 2399576 2399576 defendant Snoryng Arnold gent 590847 590847 Snoryng, Arnold, of Saham, gent 1
5149690 2401038 2401038 defendant Calmak John carpenter 590847 590847 Calmak, John, of Saham, carpenter 0
5179328 2409692 2409692 defendant Snoryng Arnold gent 590847 590847 Snoryng, Arnold, of Saham, gent 0
5179331 2409693 2409693 defendant Snoryng Arnold gent 590847 590847 Snoryng, Arnold, of Saham, gent 0
5179334 2409694 2409694 defendant Snoryng Arnold gent 590847 590847 Snoryng, Arnold, of Saham, gent 0
5196662 2414777 2414777 defendant Wolmer Alexander husbandman 590847 590847 Wolmer, Alexander, of Saham, husbandman 1
5200331 2415855 2415855 defendant Bothe Henry husbandman 590847 590847 Bothe, Henry, of Saham, husbandman 0
5201851 2416308 2416308 defendant Snoryng Arnold gent 590847 590847 Snoryng, Arnold, of Saham, gent 0
5211457 2419084 2419084 defendant Beche Henry husbandman 590847 590847 Beche, Henry, of Saham, husbandman 0
5230972 2424666 2424666 defendant Wryght Richard gent 590847 590847 Wryght, Richard, of Saham, gent 0
5283486 2440222 2440222 defendant Salesbury Robert husbandman 590847 590847 Salesbury, Robert, of Saham, husbandman 0
5283488 2440223 2440223 defendant Salesbury Robert husbandman 590847 590847 Salesbury, Robert, of Saham, husbandman 0
5283489 2440223 2440223 defendant Thorneton John husbandman 590847 590847 Thorneton, John, of Saham, husbandman 1
5283491 2440224 2440224 defendant Salesbury Robert husbandman 590847 590847 Salesbury, Robert, of Saham, husbandman 0
5283492 2440224 2440224 defendant Thorneton John husbandman 590847 590847 Thorneton, John, of Saham, husbandman 1
5334419 2455365 2455365 defendant Wryght Richard gent 590847 590847 Wryght, Richard, of Saham, gent 1
5350534 2460288 2460288 plaintiff Coo John   590847 590847 Coo, John, of Saham 0
5350537 2460288 2460288 plaintiff Gybbys Roger   590847 590847 Gybbys, Roger, of Saham 3
5533922 2515151 2515151 defendant Koo Hugh gent 590847 590847 Koo, Hugh, of Saham, gent 0
5560151 2522932 2522932 plaintiff Skygge alias Lokton Walter   590847 590847 Skygge alias Lokton, Walter, of Saham 0
5578516 2528352 2528352 defendant Atkynson Robert chaplain 590847 590847 Atkynson, Robert, of Saham, chaplain 0

Next page

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