names

47 rows where place_id = 768689

✎ 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
4414111 2169318 2169318 defendant Alleslee Richard   768689 768689 Alleslee, Richard, of Harrietsham, parson 2
4415851 2169847 2169847 defendant Taillour John le   768689 768689 Taillour, John le, of Harrietsham, son of William 0
4432239 2174865 2174865 defendant Allesle Richard   768689 768689 Allesle, Richard, of Harrietsham, parson 2
4551275 2216337 2216337 defendant Walter Richard   768689 768689 Walter, Richard, of Harrietsham 1
4551276 2216337 2216337 defendant Boner William   768689 768689 Boner, William, of Harrietsham 2
4575458 2223835 2223835 defendant Walter Richard   768689 768689 Walter, Richard, of Harrietsham 1
4575483 2223843 2223843 defendant Walter Richard   768689 768689 Walter, Richard, of Harrietsham 0
4575488 2223843 2223843 defendant Skynner John   768689 768689 Skynner, John, of Harrietsham 5
4583987 2226410 2226410 defendant Stede John   768689 768689 Stede, John, of Harrietsham 1
4608451 2233750 2233750 defendant Walter Richard   768689 768689 Walter, Richard, of Harrietsham 2
4614886 2235662 2235662 defendant atte Rode John   768689 768689 atte Rode, John, of Harrietsham 1
4614889 2235663 2235663 defendant atte Rode John   768689 768689 atte Rode, John, of Harrietsham 1
4629921 2240278 2240278 defendant Walter John   768689 768689 Walter, John, of Harrietsham 0
4640882 2243432 2243432 defendant Scot Richard   768689 768689 Scot, Richard, of Harrietsham 0
4715411 2270157 2270157 plaintiff Waltere Richard   768689 768689 Waltere, Richard, of Harrietsham 0
4725269 2273193 2273193 defendant Bakere John husbandman 768689 768689 Bakere, John, of Harrietsham, husbandman 4
4727756 2273924 2273924 defendant Walter John butcher 768689 768689 Walter, John, of Harrietsham, butcher 1
4732727 2275416 2275416 defendant Walter John husbandman 768689 768689 Walter, John, of Harrietsham, husbandman 0
4747636 2279816 2279816 defendant Baye John de, senior   768689 768689 Baye, John de, senior, of Harrietsham, fish seller 3
4747637 2279816 2279816 defendant Baye John de, junior   768689 768689 Baye, John de, junior, of Harrietsham, fish seller 4
4759141 2283205 2283205 defendant Hamon Hamond laborer 768689 768689 Hamon, Hamond, of Harrietsham, laborer 4
4759147 2283206 2283206 defendant Hamon Hamonus laborer 768689 768689 Hamon, Hamonus, of Harrietsham, laborer 4
4828101 2304832 2304832 defendant Mayhewe Philip weaver 768689 768689 Mayhewe, Philip, of Harrietsham, weaver 0
4832512 2306194 2306194 defendant Rasyl William husbandman 768689 768689 Rasyl, William, of Harrietsham, husbandman 1
4987468 2353208 2353208 defendant Eytherst William laborer 768689 768689 Eytherst, William, of Harrietsham, laborer 0
4997173 2356008 2356008 defendant Taillour John laborer 768689 768689 (Taillour, John, of Harrietsham, laborer 2
4997174 2356008 2356008 defendant Pilcher Thomas smith 768689 768689 Pilcher, Thomas, of Harrietsham, smith 3
5038428 2368128 2368128 defendant Felde Alexander husbandman 768689 768689 Felde, Alexander, of Harrietsham, husbandman 3
5130364 2395369 2395369 defendant Beamond William seller of fish 768689 768689 Beamond, William, of Harrietsham, seller of fish 3
5147757 2400485 2400485 defendant Gerveys Hamond   768689 768689 Gerveys, Hamond, of Harrietsham, inland fish seller 0
5149721 2401050 2401050 defendant Bemond William   768689 768689 Bemond, William, of Harrietsham, inland fish seller 3
5150578 2401312 2401312 defendant Hunte Thomas carpenter 768689 768689 Hunte, Thomas, of Harrietsham, carpenter 0
5155409 2402735 2402735 defendant Screvener William skinner 768689 768689 Screvener, William, of Harrietsham, skinner 0
5168566 2406523 2406523 defendant Bemond William   768689 768689 Bemond, William, of Harrietsham, inland fish seller 3
5172061 2407544 2407544 defendant Screvener William skinner 768689 768689 Screvener, William, of Harrietsham, skinner 0
5191046 2413124 2413124 defendant Screvener William skinner 768689 768689 Screvener, William, of Harrietsham, skinner 0
5191376 2413218 2413218 defendant Baker William   768689 768689 Baker, William, of Harrietsham, inland fish seller 0
5191384 2413221 2413221 defendant Baker William   768689 768689 Baker, William, of Harrietsham, inland fish seller 0
5200274 2415839 2415839 defendant Rust Richard   768689 768689 Rust, Richard, of Harrietsham, inland fish seller 3
5204800 2417153 2417153 defendant Hunte Thomas carpenter 768689 768689 Hunte, Thomas, of Harrietsham, carpenter 0
5207319 2417882 2417882 defendant Baker William   768689 768689 Baker, William, of Harrietsham, inland fish seller 0
5210272 2418732 2418732 defendant Clerk William   768689 768689 Clerk, William, of Harrietsham, inland fish seller 0
5297853 2444379 2444379 defendant Rust Thomas   768689 768689 Rust, Thomas, of Harrietsham 1
5306401 2446899 2446899 defendant German Hamond husbandman 768689 768689 German, Hamond, of Harrietsham, husbandman 0
5306499 2446933 2446933 defendant German Hamond husbandman 768689 768689 German, Hamond, of Harrietsham, husbandman 0
5401133 2475388 2475388 defendant Pilcher Richard smith 768689 768689 Pilcher, Richard, of Harrietsham, smith 1
5449021 2489600 2489600 defendant Taylor John butcher 768689 768689 Taylor, John, of Harrietsham, butcher 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);