names

44 rows where place_id = 610052

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3681717 1920379 1920379 defendant Clerk Robert clothier 610052 610052 Clerk, Robert, of Cressyng, clothier 1
3691470 1923487 1923487 defendant Draper Robert   610052 610052 Draper, Robert, of Cressyng, pale maker 0
3834208 1968640 1968640 defendant Smyth Thomas gent 610052 610052 Smyth, Thomas, of Cressyng, gent 0
3892485 1987733 1987733 defendant Smyth Thomas gent 610052 610052 Smyth, Thomas, of Cressyng, gent 0
4442685 2182661 2182661 defendant Alldam Thomas   610052 610052 Alldam, Thomas, of Cressyng 0
4451984 2185605 2185605 defendant Adam Thomas   610052 610052 Adam, Thomas, of Cressyng 0
4451989 2185607 2185607 defendant Adam Thomas   610052 610052 Adam, Thomas, of Cressyng 0
4451991 2185608 2185608 defendant Adam Thomas   610052 610052 Adam, Thomas, of Cressyng 0
4493122 2198551 2198551 defendant May John   610052 610052 May, John, of Cressyng 0
4611649 2234705 2234705 plaintiff Cokes Lawrence   610052 610052 Cokes, Lawrence, of Cressyng 0
4647711 2245389 2245389 plaintiff Smyth John   610052 610052 Smyth, John, of Cressyng 0
4686500 2261385 2261385 plaintiff Smyth John   610052 610052 Smyth, John, of Cressyng 0
4693177 2263369 2263369 plaintiff Barbour Robert   610052 610052 Barbour, Robert, of Cressyng 0
4735069 2276117 2276117 plaintiff Smyth John   610052 610052 Smyth, John, of Cressyng 0
4822142 2303002 2303002 defendant Smyth John husbandman 610052 610052 Smyth, John, of Cressyng, husbandman 0
4877693 2319984 2319984 defendant Tyler John husbandman 610052 610052 Tyler, John, of Cressyng, husbandman 3
4879364 2320475 2320475 plaintiff Tyler John   610052 610052 Tyler, John, of Cressyng 0
4950203 2342028 2342028 defendant Barnard William smith 610052 610052 Barnard, William, of Cressyng, smith 0
4979692 2350882 2350882 defendant Stokes Thomas husbandman 610052 610052 Stokes, Thomas, of Cressyng, husbandman 1
4979693 2350882 2350882 defendant Waltam John husbandman 610052 610052 Waltam, John, of Cressyng, husbandman 2
4992576 2354664 2354664 plaintiff Smyth John   610052 610052 Smyth, John, of Cressyng 4
5037273 2367773 2367773 defendant Reynald John carpenter 610052 610052 Reynald, John, of Cressyng, carpenter 0
5055961 2373352 2373352 defendant Cukkoke Thomas laborer 610052 610052 Cukkoke, Thomas, of Cressyng, laborer 0
5056407 2373490 2373490 defendant Sandon John cordwainer 610052 610052 Sandon, John, of Cressyng, cordwainer 1
5056849 2373622 2373622 defendant Mason John husbandman 610052 610052 Mason, John, of Cressyng, husbandman 0
5071771 2378050 2378050 defendant Reynold John carpenter 610052 610052 Reynold, John, of Cressyng, carpenter 1
5092169 2384085 2384085 defendant Bernard William smith 610052 610052 Bernard, William, of Cressyng, smith 0
5092170 2384085 2384085 defendant Sorell John husbandman 610052 610052 Sorell, John, of Cressyng, husbandman 1
5105071 2387917 2387917 defendant Sorell William husbandman 610052 610052 Sorell, William, of Cressyng, husbandman 3
5135342 2396839 2396839 defendant Clerk Thomas husbandman 610052 610052 Clerk, Thomas, of Cressyng, husbandman 0
5145925 2399934 2399934 defendant Sandon John husbandman 610052 610052 Sandon, John, of Cressyng, husbandman 0
5151334 2401540 2401540 defendant Smyth John yeoman 610052 610052 Smyth, John, of Cressyng, yeoman 2
5153776 2402265 2402265 defendant Sandon John husbandman 610052 610052 Sandon, John, of Cressyng, husbandman 1
5169508 2406820 2406820 defendant Smyth John yeoman 610052 610052 Smyth, John, of Cressyng, yeoman 2
5171168 2407289 2407289 defendant Sandon John husbandman 610052 610052 Sandon, John, of Cressyng, husbandman 1
5186426 2411785 2411785 defendant Smyth John yeoman 610052 610052 Smyth, John, of Cressyng, yeoman 2
5187350 2412026 2412026 defendant Bernard William husbandman 610052 610052 Bernard, William, of Cressyng, husbandman 1
5199912 2415726 2415726 defendant Tyler John   610052 610052 Tyler, John, of Cressyng, tile maker 0
5205565 2417374 2417374 defendant Bernard William husbandman 610052 610052 Bernard, William, of Cressyng, husbandman 1
5211338 2419046 2419046 defendant Tyler John tiler 610052 610052 Tyler, John, of Cressyng, tiler 0
5272690 2437090 2437090 defendant Cuttyng John husbandman 610052 610052 Cuttyng, John, of Cressyng, husbandman 0
5372949 2467130 2467130 defendant Lytilbury William butcher 610052 610052 Lytilbury, William, of Cressyng, butcher 1
5488130 2501341 2501341 defendant Rochand John, senior husbandman 610052 610052 Rochand, John, senior, of Cressyng, husbandman 0
5615069 2548503 2548503 plaintiff Fresell John   610052 610052 Fresell, John, of Cressyng 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);