names

62 rows where place_id = 664258

✎ 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
3972125 2014812 2014812 defendant Questonbery Henry tailor 664258 664258 Questonbery, Henry, of Leed, tailor 0
3975977 2016163 2016163 plaintiff Jaye John husbandman 664258 664258 Jaye, John, of Leed, husbandman 0
4007584 2027497 2027497 defendant Martyn Thomas yeoman 664258 664258 Martyn, Thomas, of Leed, yeoman 0
4033517 2036645 2036645 defendant Allen Alexander draper 664258 664258 Allen, Alexander, of Leed, draper 3
4033518 2036645 2036645 defendant Fawkyngham John gent 664258 664258 Fawkyngham, John, of Leed, gent 4
4033519 2036645 2036645 defendant Ambler Thomas clothier 664258 664258 Ambler, Thomas, of leed, clothier 5
4034504 2037012 2037012 plaintiff Harryson John clothier 664258 664258 Harryson, John, of Leed, clothier 0
4051402 2042924 2042924 plaintiff Wilkingson Abraham chapman 664258 664258 Wilkingson, Abraham, of Leed, chapman 0
4121963 2068155 2068155 defendant Towne John yeoman 664258 664258 Towne, John, of Leed, yeoman 1
4138638 2074186 2074186 defendant Crowmake Thomas clothier 664258 664258 Crowmake, Thomas, of Leed, clothier 0
4149678 2078013 2078013 defendant Questonbery Henry tailor 664258 664258 Questonbery, Henry, of Leed, tailor 0
4159284 2081318 2081318 defendant Graye William husbandman 664258 664258 Graye, William, of Leed, or of Balithorpe, Rutland, husbandman 0
4169549 2084854 2084854 defendant Numbie Thomas clothier 664258 664258 Numbie, Thomas, of Leed, clothier 0
4169672 2084883 2084883 defendant Headley Martin tailor 664258 664258 Headley, Martin, of Leed, tailor 0
4176683 2087314 2087314 defendant Francklyn John gent 664258 664258 Francklyn, John, of Leed, gent 0
4177151 2087482 2087482 defendant Broke William clothier 664258 664258 Broke, William, of Leed, clothier 0
4181712 2089085 2089085 defendant Wilkenson Abraham yeoman 664258 664258 Wilkenson, Abraham, of Leed, yeoman 1
4182505 2089359 2089359 defendant Fenton John laborer 664258 664258 Fenton, John, of Leed, laborer 0
4182856 2089484 2089484 defendant Realme Thomas miller 664258 664258 Realme, Thomas, of Leed, miller 1
4184647 2090139 2090139 defendant Shawe Richard butcher 664258 664258 Shawe, Richard, of Leed, butcher 2
4189051 2091658 2091658 defendant Barnard Thomas   664258 664258 Barnard, Thomas, of Leed, yeoman, alias Thomas Barnet, of St Peters, St Albans, Herts 0
4189926 2091979 2091979 defendant Edwarde William butcher 664258 664258 Edwarde, William, of Leed, butcher 0
4190138 2092057 2092057 defendant Dawson Lancelot clothier 664258 664258 Dawson, Lancelot, of Leed, clothier 0
4190139 2092057 2092057 defendant Wrether alias Logwood Robert clothier 664258 664258 Wrether alias Logwood, Robert, of Leed, clothier 1
4191696 2092650 2092650 defendant Francklyn John gent 664258 664258 Francklyn, John, of Leed, gent 0
4213197 2100135 2100135 defendant Ambler Daniel clothier 664258 664258 Ambler, Daniel, of Leed, clothier 1
4224593 2104078 2104078 defendant Jackson Thomas clothier 664258 664258 Jackson, Thomas, of Leed, clothier 0
4228310 2105382 2105382 defendant Craven John clothier 664258 664258 Craven, John, of Leed, clothier 2
4229586 2105833 2105833 defendant Waddesworth William yeoman 664258 664258 Waddesworth, William, of Leed, yeoman 0
4260400 2116445 2116445 defendant Casson John yeoman 664258 664258 Casson, John, of Leed, yeoman 1
4261025 2116652 2116652 defendant Wilkinson John laborer 664258 664258 Wilkinson, John, of Leed, laborer 1
4261026 2116652 2116652 defendant Thorpe John gent 664258 664258 Thorpe, John, of Leed, gent 2
4262686 2117190 2117190 defendant Savile Edward gent 664258 664258 Savile, Edward, of Leed, gent 1
4263404 2117421 2117421 defendant Folkingham John gent 664258 664258 Folkingham, John, of Leed, gent 1
4265190 2117994 2117994 defendant Killingbeck William yeoman 664258 664258 Killingbeck, William, of Leed, yeoman 0
4273995 2120847 2120847 defendant Folkingham John gent 664258 664258 Folkingham, John, of Leed, gent 1
4275494 2121368 2121368 defendant Ambler Thomas clothier 664258 664258 Ambler, Thomas, of Leed, clothier 0
4275495 2121368 2121368 defendant Smyth John   664258 664258 Smyth, John, of Leed, card maker 1
4280052 2122933 2122933 defendant Jeffrey William clothier 664258 664258 Jeffrey, William, of Leed, clothier 0
4280054 2122934 2122934 defendant Jeffrey William clothier 664258 664258 Jeffrey, William, of Leed, clothier 0
4283951 2124302 2124302 defendant Stles Robert yeoman 664258 664258 Stles, Robert, of Leed, yeoman 0
4292103 2127249 2127249 defendant Browne Thomas clothier 664258 664258 Browne, Thomas, of Leed, clothier 1
4336640 2142541 2142541 defendant Reynold Edward clothier 664258 664258 Reynold, Edward, of Leed, clothier 0
4344775 2145452 2145452 defendant Reynold Edward yeoman 664258 664258 Reynold, Edward, of Leed, yeoman 0
4349951 2147243 2147243 defendant Jefferson William clothier 664258 664258 Jefferson, William, of Leed, clothier 0
4349952 2147243 2147243 defendant Walker John clothier 664258 664258 Walker, John, of Leed, clothier 1
4349954 2147243 2147243 defendant Franckland Thomas dyer 664258 664258 Franckland, Thomas, of Leed, dyer 3
4360019 2150747 2150747 defendant Reynold Edward yeoman 664258 664258 Reynold, Edward, of Leed, yeoman 1
4360020 2150747 2150747 defendant Reynold Richard yeoman 664258 664258 Reynold, Richard, of Leed, yeoman 2
4370729 2154584 2154584 defendant Mason Richard yeoman 664258 664258 Mason, Richard, of Leed, yeoman 0
4385354 2159792 2159792 defendant Hudson John laborer 664258 664258 Hudson, John, of Leed, laborer 0
4386150 2160049 2160049 defendant Ambler James baker 664258 664258 Ambler, James, of Leed, baker 3
4386827 2160262 2160262 defendant Jackson Robert chapman 664258 664258 Jackson, Robert, of Leed, chapman 2
4393593 2162460 2162460 defendant Kynnersley William gent 664258 664258 Kynnersley, William, of Leed, gent 0
4393594 2162460 2162460 defendant Dymock John gent 664258 664258 Dymock, John, of Leed, or of Thornton, Lincs, gent 1
4398374 2164038 2164038 defendant Fletcher William yeoman 664258 664258 Fletcher, William, of Leed, yeoman 0
4398376 2164038 2164038 defendant Smyth Henry yeoman 664258 664258 Smyth, Henry, of Leed, yeoman 2
4398377 2164038 2164038 defendant Ball Robert yeoman 664258 664258 Ball, Robert, of Leed, yeoman 3
4406258 2166656 2166656 defendant Hirst Robert yeoman 664258 664258 (Hirst, Robert, of Leed, yeoman 4
4412468 2168760 2168760 defendant Coldcole Brian   664258 664258 Coldcole, Brian, of Leed chapman 1
5589966 2531844 2531844 defendant Sherecroft Richard miller 664258 664258 Sherecroft, Richard, of Leed, miller 1
5589969 2531845 2531845 defendant Sherecroft Richard miller 664258 664258 Sherecroft, Richard, of Leed, miller 1

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