names

69 rows where place_id = 587726

✎ 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
3592257 1865192 1865192 defendant Southawe John yeoman 587726 587726 Southawe, John, of Combys, yeoman 0
3627591 1903488 1903488 defendant Thurmewode Richard yeoman 587726 587726 Thurmewode, Richard, of Combys, yeoman 2
3679556 1919674 1919674 defendant Warryson William chaplain 587726 587726 Warryson, William, of Combys, chaplain 2
3697820 1925536 1925536 defendant Whitman Simon husbandman 587726 587726 Whitman, Simon, of Combys, husbandman 3
3698650 1925793 1925793 defendant Thurmode Thomas husbandman 587726 587726 Thurmode, Thomas, of Combys, husbandman 0
3698652 1925794 1925794 defendant Thurmode Thomas husbandman 587726 587726 Thurmode, Thomas, of Combys, husbandman 0
3699190 1925960 1925960 defendant Cooke Roger glover 587726 587726 Cooke, Roger, of Combys, glover 0
3723931 1933764 1933764 defendant Thorp William clothmaker 587726 587726 Thorp, William, of Combys, clothmaker 2
3729771 1935567 1935567 defendant Thorp William clothmaker 587726 587726 Thorp, William, of Combys, clothmaker 0
3732232 1936319 1936319 defendant Kegyll John smith 587726 587726 Kegyll, John, of Combys, smith 0
3742168 1939417 1939417 defendant Baxter Roger sherman 587726 587726 Baxter, Roger, of Combys, sherman 0
3742171 1939418 1939418 defendant Braxter Roger sherman 587726 587726 Braxter, Roger, of Combys, sherman 0
3797916 1957246 1957246 defendant Awood William smith 587726 587726 Awood, William, of Combys, smith 0
3805624 1959702 1959702 defendant Fraunces Robert husbandman 587726 587726 Fraunces, Robert, of Combys, husbandman 2
3805625 1959702 1959702 defendant Austen Edmund husbandman 587726 587726 Austen, Edmund, of Combys, husbandman 3
3842588 1971210 1971210 defendant Copy Thomas butcher 587726 587726 Copy, Thomas, of Combys, butcher 0
3876750 1982467 1982467 defendant Sannsom Robert thatcher 587726 587726 Sannsom, Robert, of Combys, thatcher 1
3921953 1997685 1997685 defendant Fraunce Robert husbandman 587726 587726 Fraunce, Robert, of Combys, husbandman 2
3938766 2003305 2003305 defendant Baxster Henry   587726 587726 Baxster, Henry, of Combys 2
4571744 2222746 2222746 defendant Rome John   587726 587726 Rome, John, of Combys 0
4832362 2306156 2306156 plaintiff Cambre John carpenter 587726 587726 Cambre, John, of Combys, carpenter 0
4835396 2307067 2307067 defendant Skryvenere John husbandman 587726 587726 Skryvenere, John, of Combys, husbandman 2
4841449 2308858 2308858 defendant Hybbeys Gilbert husbandman 587726 587726 Hybbeys, Gilbert, of Combys, husbandman 1
4869111 2317312 2317312 defendant Hybbeys Gilbert husbandman 587726 587726 Hybbeys, Gilbert, of Combys, husbandman 1
4882195 2321335 2321335 defendant Oke Thomas husbandman 587726 587726 Oke, Thomas, of Combys, husbandman 0
4882199 2321337 2321337 defendant Hobbes Gilbert husbandman 587726 587726 Hobbes, Gilbert, of Combys, husbandman 0
4911009 2329953 2329953 defendant Dowerys Robert tanner 587726 587726 Dowerys, Robert, of Combys, tanner 2
4912124 2330293 2330293 defendant Cok Thomas yeoman 587726 587726 Cok, Thomas, of Combys, yeoman 0
4913592 2330749 2330749 plaintiff Cok Thomas   587726 587726 Cok, Thomas, of Combys 0
4913593 2330749 2330749 plaintiff Bewmays William   587726 587726 Bewmays, William, of Combys 1
4913594 2330749 2330749 defendant Hebbys Gilbert yeoman 587726 587726 Hebbys, Gilbert, of Combys, yeoman 0
4926108 2334592 2334592 defendant Franle or Fraule John carpenter 587726 587726 Franle or Fraule, John, of Combys, carpenter 3
4939975 2338890 2338890 defendant Hebbys Gilbert husbandman 587726 587726 Hebbys, Gilbert, of Combys, husbandman 3
4965758 2346685 2346685 defendant Nobbys Reginald husbandman 587726 587726 Nobbys, Reginald, of Combys, husbandman 4
4976258 2349850 2349850 defendant Nobbys Reginald husbandman 587726 587726 Nobbys, Reginald, of Combys, husbandman 4
5017332 2361957 2361957 defendant Cambyr John husbandman 587726 587726 Cambyr, John, of Combys, husbandman 1
5127362 2394485 2394485 defendant Adgore John yeoman 587726 587726 Adgore, John, of Combys, yeoman 0
5127363 2394485 2394485 defendant Wryghte John clerk 587726 587726 Wryghte, John, of Combys, clerk 1
5129835 2395212 2395212 defendant Hegekyn John laborer 587726 587726 Hegekyn, John, of Combys, laborer 5
5141114 2398525 2398525 defendant Adgore John yeoman 587726 587726 Adgore, John, of Combys, yeoman 4
5146249 2400033 2400033 defendant Adgore John yeoman 587726 587726 Adgore, John, of Combys, yeoman 0
5146250 2400033 2400033 defendant Wryghte John clerk 587726 587726 Wryghte, John, of Combys, clerk 1
5162297 2404700 2404700 defendant Adgore John yeoman 587726 587726 Adgore, John, of Combys, yeoman 4
5164350 2405308 2405308 defendant Smyth Thomas dyer 587726 587726 Smyth, Thomas, of Combys, dyer 1
5164351 2405308 2405308 defendant Edgore John husbandman 587726 587726 Edgore, John, of Combys, husbandman 2
5164355 2405309 2405309 defendant Smyth Thomas dyer 587726 587726 Smyth, Thomas, of Combys, dyer 1
5164356 2405309 2405309 defendant Edgore John husbandman 587726 587726 Edgore, John, of Combys, husbandman 2
5166455 2405914 2405914 defendant Adgore John yeoman 587726 587726 Adgore, John, of Combys, yeoman 0
5166456 2405914 2405914 defendant Wryghte John clerk 587726 587726 Wryghte, John, of Combys, clerk 1
5183937 2411037 2411037 defendant Hogelyn John laborer 587726 587726 Hogelyn, John, of Combys, laborer 5
5202810 2416590 2416590 defendant Adgore John yeoman 587726 587726 Adgore, John, of Combys, yeoman 0
5202811 2416590 2416590 defendant Wryghte John clerk 587726 587726 Wryghte, John, of Combys, clerk 1
5211841 2419202 2419202 defendant Denys John husbandman 587726 587726 Denys, John, of Combys, husbandman 0
5211843 2419202 2419202 defendant Fuller John husbandman 587726 587726 Fuller, John, of Combys, husbandman 2
5216710 2420622 2420622 plaintiff Deynys Thomas   587726 587726 Deynys, Thomas, of Combys 0
5216711 2420622 2420622 defendant Treker Richard yeoman 587726 587726 Treker, Richard, of Combys, yeoman 0
5216712 2420622 2420622 defendant Smyth alias Anour or Avour Thomas yeoman 587726 587726 Smyth alias Anour or Avour, Thomas, of Combys, yeoman 1
5297966 2444417 2444417 plaintiff Bakke John   587726 587726 Bakke, John, of Combys 0
5331768 2454582 2454582 defendant Smyth Thomas yeoman 587726 587726 Smyth, Thomas, of Combys, yeoman 1
5355502 2461794 2461794 defendant Ive William yeoman 587726 587726 Ive, William, of Combys, yeoman 0
5426829 2482967 2482967 defendant Glutter John husbandman 587726 587726 Glutter, John, of Combys, husbandman 1
5433968 2485113 2485113 defendant Fraunceys John husbandman 587726 587726 Fraunceys, John, of Combys, husbandman 0
5444812 2488343 2488343 defendant Slutter John husbandman 587726 587726 Slutter, John, of Combys, husbandman 1
5444819 2488344 2488344 defendant Glutter John husbandman 587726 587726 Glutter, John, of Combys, att Hyll by Bramber, husbandman 1
5476056 2497852 2497852 defendant Smyth William yeoman 587726 587726 Smyth, William, of Combys, yeoman 3
5490564 2502069 2502069 defendant Smyth William courser 587726 587726 Smyth, William, of Combys, courser 0
5507608 2507277 2507277 defendant Smyth William yeoman 587726 587726 Smyth, William, of Combys, yeoman 0
5509444 2507803 2507803 defendant Southawe John yeoman 587726 587726 Southawe, John, of Combys, yeoman 0
5583219 2529828 2529828 defendant Thurmode John yeoman 587726 587726 Thurmode, John, of Combys, yeoman 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);