names

26 rows where place_id = 758500

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3752024 1942555 1942555 defendant Carpynter John   758500 758500 Carpynter, John, of Hornyngesham, twllow chandler 0
4454413 2186391 2186391 plaintiff Lynstede John   758500 758500 Lynstede, John, of Hornyngesham, prebendary 0
4454414 2186391 2186391 defendant Wayghts Robert   758500 758500 Wayghts, Robert, of Hornyngesham 0
4540597 2212956 2212956 defendant Nony Edward   758500 758500 Nony, Edward, of Hornyngesham 6
4631902 2240862 2240862 defendant Fysshe James   758500 758500 Fysshe, James, of Hornyngesham 0
4633669 2241379 2241379 defendant Mody William   758500 758500 Mody, William, of Hornyngesham 1
4700154 2265470 2265470 defendant Mody William husbandman 758500 758500 Mody, William, of Hornyngesham, husbandman 0
4712822 2269318 2269318 defendant Mody William husbandman 758500 758500 Mody, William, of Hornyngesham, husbandman 4
4730802 2274835 2274835 defendant Sprynt Thomas husbandman 758500 758500 Sprynt, Thomas, of Hornyngesham, husbandman 0
5064536 2375931 2375931 defendant Tullok John tucker 758500 758500 Tullok, John, of Hornyngesham, tucker 0
5075501 2379169 2379169 defendant Tullok John tucker 758500 758500 Tullok, John, of Hornyngesham, tucker 0
5078776 2380140 2380140 defendant Tullok John tucker 758500 758500 Tullok, John, of Hornyngesham, tucker 0
5082555 2381289 2381289 defendant Bocher Thomas husbandman 758500 758500 Bocher, Thomas, of Hornyngesham, husbandman 0
5120503 2392426 2392426 defendant Botelar John chaplain 758500 758500 Botelar, John, of Hornyngesham, chaplain 0
5124598 2393665 2393665 defendant Tullok Henry clothier 758500 758500 Tullok, Henry, of Hornyngesham, clothier 0
5127090 2394401 2394401 defendant Tullok John clothier 758500 758500 Tullok, John, of Hornyngesham, clothier 0
5202678 2416544 2416544 defendant Tullok John clothier 758500 758500 Tullok, John, of Hornyngesham, clothier 0
5214855 2420064 2420064 plaintiff Carpenter Edward (legal representative) 758500 758500 Carpenter, Edward, of Hornyngesham, executors of 0
5220795 2421773 2421773 defendant Snell or Suell John husbandman 758500 758500 Snell or Suell, John, of Hornyngesham, husbandman 0
5220796 2421773 2421773 defendant Hancok John husbandman 758500 758500 Hancok, John, of Hornyngesham, husbandman 1
5221890 2422103 2422103 defendant Rawelyns John husbandman 758500 758500 Rawelyns, John, of Hornyngesham, husbandman 0
5255350 2431788 2431788 defendant Sprente Richard husbandman 758500 758500 Sprente, Richard, of Hornyngesham, husbandman 3
5361812 2463722 2463722 defendant Huysshe Thomas tucker 758500 758500 Huysshe, Thomas, of Hornyngesham, tucker 5
5377731 2468619 2468619 defendant Nyrsshe Thomas yeoman 758500 758500 Nyrsshe, Thomas, of Hornyngesham, yeoman 1
5521185 2511443 2511443 defendant Jenkyns John glover 758500 758500 Jenkyns, John, of Hornyngesham, glover 1
5634232 2554689 2554689 defendant Cleyvyle alias Balstake John dyer 758500 758500 Cleyvyle alias Balstake, John, of Hornyngesham, dyer 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);