names

29 rows where place_id = 747159

✎ 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
4376249 2156572 2156572 defendant Crane Peter yeoman 747159 747159 Crane, Peter, of Appledore, yeoman 0
4376250 2156572 2156572 defendant Moone Henry yeoman 747159 747159 Moone, Henry, of Appledore, yeoman 1
4605807 2232930 2232930 defendant Rokker Walter   747159 747159 Rokker, Walter, of Appledore 2
4605809 2232930 2232930 defendant Cook Augustine   747159 747159 Cook, Augustine, of Appledore 4
4696669 2264434 2264434 defendant Umfray William husbandman 747159 747159 Umfray, William, of Appledore, husbandman 1
4721861 2272171 2272171 defendant Grofe Thomas husbandman 747159 747159 Grofe, Thomas, of Appledore, husbandman 0
4728820 2274251 2274251 defendant White Geoffrey smith 747159 747159 White, Geoffrey, of Appledore, smith 0
4773626 2287722 2287722 defendant Peek John laborer 747159 747159 Peek, John, of Appledore, laborer 0
4831832 2305975 2305975 defendant Lang Thomas yeoman 747159 747159 Lang, Thomas, of Appledore, yeoman 0
4832635 2306229 2306229 defendant Edward William carpenter 747159 747159 Edward, William, of Appledore, carpenter 0
4986020 2352736 2352736 defendant Have or Hane John   747159 747159 Have or Hane, John, of Appledore 0
4987333 2353161 2353161 defendant Swan Richard tailor 747159 747159 Swan, Richard, of Appledore, tailor 0
5179205 2409654 2409654 defendant Reyhold Thomas laborer 747159 747159 Reyhold, Thomas, of Appledore, laborer 1
5201801 2416293 2416293 defendant Reyn Thomas laborer 747159 747159 Reyn, Thomas, of Appledore, laborer 1
5300055 2444982 2444982 defendant Spycer John hosier 747159 747159 Spycer, John, of Appledore, hosier 0
5302121 2445590 2445590 defendant Overton Robert   747159 747159 Overton, Robert, of Appledore, clerk & parson of the church of St Peter, in Dover 0
5303176 2445942 2445942 defendant Broun John husbandman 747159 747159 Broun, John, of Appledore, husbandman 1
5376338 2468196 2468196 defendant Ketyng Willam husbandman 747159 747159 Ketyng, Willam, of Appledore, husbandman 1
5376349 2468200 2468200 defendant Snyngham or Suyngham Richard husbandman 747159 747159 Snyngham or Suyngham, Richard, of Appledore, husbandman 1
5401848 2475594 2475594 defendant Rigge Richard husbandman 747159 747159 Rigge, Richard, of Appledore, husbandman 1
5401849 2475594 2475594 defendant Hancok Lawrence husbandman 747159 747159 Hancok, Lawrence, of Appledore, husbandman 2
5410289 2478030 2478030 defendant Knyght Petronella (legal representative) 747159 747159 Knyght, Petronella, of Appledore, executor of 1
5410795 2478176 2478176 defendant B_ John husbandman 747159 747159 B_, John, of Appledore, husbandman 0
5424119 2482176 2482176 defendant Knyght Parnel (legal representative) 747159 747159 Knyght, Parnel, of Appledore, executor of 1
5424123 2482177 2482177 defendant Knyght Petronella (legal representative) 747159 747159 Knyght, Petronella, of Appledore, executor of 1
5443108 2487850 2487850 defendant Knight Petronella (legal representative) 747159 747159 Knight, Petronella, of Appledore, executor of 1
5447310 2489084 2489084 defendant Hancok Lawrence husbandman 747159 747159 Hancok, Lawrence, of Appledore, husbandman 0
5456267 2491790 2491790 defendant Hancok Lawrence husbandman 747159 747159 Hancok, Lawrence, of Appledore, husbandman 0
5467671 2495262 2495262 defendant Knyght Parnel (legal representative) 747159 747159 Knyght, Parnel, of Appledore, executor of 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);