names

30 rows where place_id = 653936

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3930412 2000518 2000518 defendant Ingram Anthony husbandman 653936 653936 Ingram, Anthony, of Kenet, husbandman 0
4512910 2204471 2204471 defendant Meloun John   653936 653936 Meloun, John, of Kenet, son of John, parson 1
4519610 2206493 2206493 defendant Longe John   653936 653936 Longe, John, of Kenet 6
4519611 2206493 2206493 defendant Costeyn John   653936 653936 Costeyn, John, of Kenet 7
4522588 2207404 2207404 defendant Melon John   653936 653936 Melon, John, of Kenet, parson 0
4536457 2211679 2211679 defendant Deye Richard   653936 653936 Deye, Richard, of Kenet 2
4536460 2211679 2211679 defendant Wade John smith 653936 653936 Wade, John, of Kenet, smith 5
4554432 2217318 2217318 defendant Melon John   653936 653936 Melon, John, of Kenet, parson 0
4640656 2243375 2243375 defendant Costyn John   653936 653936 Costyn, John, of Kenet 3
4640663 2243376 2243376 defendant Costyn John   653936 653936 Costyn, John, of Kenet 3
4666475 2250995 2250995 defendant Weston John husbandman 653936 653936 Weston, John, of Kenet, husbandman 0
4671931 2256867 2256867 defendant Lacy John gent 653936 653936 Lacy, John, of Kenet, gent 0
4671932 2256867 2256867 defendant Moyell William   653936 653936 Moyell, William, of Kenet, shepherd 1
4676224 2258173 2258173 defendant Gors William   653936 653936 Gors, William, of Kenet, shepherd 1
4699747 2265364 2265364 defendant Hardyng Nicholas husbandman 653936 653936 Hardyng, Nicholas, of Kenet, husbandman 0
4700277 2265503 2265503 defendant Lacy John yeoman 653936 653936 Lacy, John, of Kenet, yeoman 2
4891626 2324120 2324120 defendant Weston William husbandman 653936 653936 Weston, William, of Kenet, husbandman 0
4899129 2326370 2326370 defendant Weston William husbandman 653936 653936 Weston, William, of Kenet, husbandman 1
4940426 2339029 2339029 defendant Lacy John yeoman 653936 653936 Lacy, John, of Kenet, yeoman 0
4989693 2353835 2353835 defendant Lacy John yeoman 653936 653936 Lacy, John, of Kenet, yeoman 1
5017248 2361928 2361928 defendant Smert John clerk 653936 653936 Smert, John, of Kenet, clerk 3
5026074 2364520 2364520 defendant Olyver William husbandman 653936 653936 Olyver, William, of Kenet, husbandman 0
5026075 2364520 2364520 defendant Parker John husbandman 653936 653936 Parker, John, of Kenet, husbandman 1
5321507 2451525 2451525 defendant Lardener alias Flemyng William (legal representative) 653936 653936 Lardener alias Flemyng, William, of Kenet, husbandman, executors of 0
5386982 2471342 2471342 defendant Selwode Thomas husbandman 653936 653936 Selwode, Thomas, of Kenet, husbandman 3
5422901 2481805 2481805 defendant Fleccher William laborer 653936 653936 Fleccher, William, of Kenet, laborer 1
5442459 2487659 2487659 defendant Fletcher William laborer 653936 653936 Fletcher, William, of Kenet, laborer 1
5455122 2491453 2491453 defendant Fleccher William laborer 653936 653936 Fleccher, William, of Kenet, laborer 1
5480812 2499219 2499219 defendant Goose Thomas husbandman 653936 653936 Goose, Thomas, of Kenet, husbandman 4
5490195 2501951 2501951 defendant Fleccher William laborer 653936 653936 Fleccher, William, of Kenet, laborer 3

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