names

58 rows where place_id = 587324

✎ 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
3591072 1864837 1864837 defendant Beeston Thomas clerk 587324 587324 Beeston, Thomas, of Ratlysden, clerk 2
3602851 1868561 1868561 defendant Tey John plumber 587324 587324 Tey, John, of Ratlysden, plumber 4
3635476 1905891 1905891 defendant Russhbroke John weaver 587324 587324 Russhbroke, John, of Ratlysden, weaver 0
3635477 1905892 1905892 plaintiff Parker William laborer 587324 587324 Parker, William, of Ratlysden, laborer 0
3645498 1908993 1908993 defendant Egyll Thomas husbandman 587324 587324 Egyll, Thomas, of Ratlysden, husbandman 2
3676111 1918568 1918568 defendant Russhebroke Thomas husbandman 587324 587324 Russhebroke, Thomas, of Ratlysden, husbandman 0
3678816 1919442 1919442 plaintiff Nunne George clothier 587324 587324 Nunne, George, of Ratlysden, clothier 0
3678818 1919443 1919443 plaintiff Nunne George clothier 587324 587324 Nunne, George, of Ratlysden, clothier 0
3683766 1921057 1921057 defendant Parker William laborer 587324 587324 Parker, William, of Ratlysden, laborer 1
3683769 1921058 1921058 defendant Parker William laborer 587324 587324 Parker, William, of Ratlysden, laborer 1
3690765 1923277 1923277 plaintiff Grome John clothmaker 587324 587324 Grome, John, of Ratlysden, clothmaker 0
3690767 1923278 1923278 plaintiff Grome John clothmaker 587324 587324 Grome, John, of Ratlysden, clothmaker 0
3702300 1926977 1926977 defendant Amore Robert husbandman 587324 587324 Amore, Robert, of Ratlysden, husbandman 0
3705093 1927883 1927883 defendant Ballys John weaver 587324 587324 Ballys, John, of Ratlysden, weaver 1
3734764 1937117 1937117 defendant More Robert laborer 587324 587324 More, Robert, of Ratlysden, laborer 7
3741184 1939102 1939102 defendant Knooke John smith 587324 587324 Knooke, John, of Ratlysden, smith 4
3791797 1955279 1955279 defendant Waren William butcher 587324 587324 Waren, William, of Ratlysden, butcher 0
3842253 1971121 1971121 defendant Edward William husbandman 587324 587324 Edward, William, of Ratlysden, husbandman 1
3888738 1986487 1986487 defendant Ely William husbandman 587324 587324 Ely, William, of Ratlysden, husbandman 0
3900245 1990310 1990310 plaintiff Bukk John husbandman 587324 587324 Bukk, John, of Ratlysden, husbandman 0
3920940 1997349 1997349 defendant Grome John clothmaker 587324 587324 Grome, John, of Ratlysden, clothmaker 0
3922651 1997892 1997892 defendant Nune Robert (legal representative) 587324 587324 Nune, Robert, of Ratlysden, tanner, executors of 0
3922652 1997892 1997892 defendant Tompson William tanner 587324 587324 (Tompson, William, of Ratlysden, tanner 1
3949450 2006881 2006881 defendant Lynge John husbandman 587324 587324 Lynge, John, of Ratlysden, husbandman 0
3952675 2008006 2008006 defendant Lynge John husbandman 587324 587324 Lynge, John, of Ratlysden, husbandman 0
3952678 2008007 2008007 defendant Lynge John husbandman 587324 587324 Lynge, John, of Ratlysden, husbandman 0
4488293 2197056 2197056 defendant Kryketot William   587324 587324 Kryketot, William, of Ratlysden, wool man 0
4606011 2232996 2232996 defendant Pumpy John   587324 587324 Pumpy, John, of Ratlysden 0
4610279 2234299 2234299 plaintiff Capell Isabel   587324 587324 Capell, Isabel, of Ratlysden 0
4645585 2244778 2244778 defendant Corde John   587324 587324 Corde, John, of Ratlysden 0
4647936 2245465 2245465 defendant Wode Richard   587324 587324 Wode, Richard, of Ratlysden 1
4724772 2273046 2273046 defendant Wode Richard   587324 587324 Wode, Richard, of Ratlysden, wool man 0
4806261 2298166 2298166 defendant Cage Thomas yeoman 587324 587324 Cage, Thomas, of Ratlysden, yeoman 2
4806269 2298167 2298167 defendant Cage Thomas yeoman 587324 587324 Cage, Thomas, of Ratlysden, yeoman 2
4883763 2321831 2321831 defendant Cage Thomas yeoman 587324 587324 Cage, Thomas, of Ratlysden, yeoman 0
4883764 2321831 2321831 defendant Leget Robert yeoman 587324 587324 Leget, Robert, of Ratlysden, yeoman 1
4904666 2328067 2328067 defendant Wedirden Peter husbandman 587324 587324 Wedirden, Peter, of Ratlysden, husbandman 1
4904667 2328067 2328067 defendant Bacon Thomas husbandman 587324 587324 Bacon, Thomas, of Ratlysden, husbandman 2
4939972 2338890 2338890 defendant Dowe John butcher 587324 587324 Dowe, John, of Ratlysden, butcher 0
4993680 2354983 2354983 defendant Kyllyngworth Joceus gent 587324 587324 Kyllyngworth, Joceus, of Ratlysden, gent 4
5009648 2359700 2359700 defendant Instan or Justan Robert   587324 587324 Instan or Justan, Robert, of Ratlysden 0
5104587 2387775 2387775 defendant Stabeler Richard husbandman 587324 587324 Stabeler, Richard, of Ratlysden, husbandman 0
5107543 2388637 2388637 defendant Mansfeld Geoffrey yeoman 587324 587324 Mansfeld, Geoffrey, of Ratlysden, yeoman 0
5244897 2428682 2428682 defendant Abell Thomas laborer 587324 587324 Abell, Thomas, of Ratlysden, laborer 2
5244898 2428682 2428682 defendant Abell John laborer 587324 587324 Abell, John, of Ratlysden, laborer 3
5244899 2428682 2428682 defendant Costard John miller 587324 587324 Costard, John, of Ratlysden, miller 4
5244900 2428682 2428682 defendant Cage Robert barker 587324 587324 Cage, Robert, of Ratlysden, barker 5
5255616 2431874 2431874 defendant Sefoull John husbandman 587324 587324 Sefoull, John, of Ratlysden, husbandman 2
5298390 2444502 2444502 defendant Donyng Henry husbandman 587324 587324 Donyng, Henry, of Ratlysden, husbandman 1
5411973 2478535 2478535 defendant Umfrey George yeoman 587324 587324 Umfrey, George, of Ratlysden, yeoman 6
5479256 2498813 2498813 plaintiff Cage Robert   587324 587324 Cage, Robert, of Ratlysden 0
5491928 2502496 2502496 defendant Scarpe William   587324 587324 Scarpe, William, of Ratlysden, tile maker 0
5513371 2509034 2509034 defendant Capron John husbandman 587324 587324 Capron, John, of Ratlysden, husbandman 0
5574239 2527030 2527030 defendant Resshbrook Seman weaver 587324 587324 Resshbrook, Seman, of Ratlysden, weaver 0
5574240 2527030 2527030 defendant Resshbrook Thomas yeoman 587324 587324 Resshbrook, Thomas, of Ratlysden, yeoman 1
5601380 2535322 2535322 defendant Roosbroke Thomas clothmaker 587324 587324 Roosbroke, Thomas, of Ratlysden, clothmaker 0
5601386 2535323 2535323 defendant Roosbroke Thomas clothmaker 587324 587324 Roosbroke, Thomas, of Ratlysden, clothmaker 0
5604699 2536333 2536333 defendant Bryggys Alexander tanner 587324 587324 Bryggys, Alexander, of Ratlysden, tanner 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);