names

26 rows where place_id = 624799

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3760348 1945239 1945239 defendant Frynd William yeoman 624799 624799 Frynd, William, of Tysherst, Sussex, yeoman 0
3971007 2014417 2014417 defendant Pryor John   624799 624799 Pryor, John, of Tysherst, Sussex, "rypyar" or fishmonger 0
4168030 2084304 2084304 defendant Smyth Stephen yeoman 624799 624799 Smyth, Stephen, of Tysherst, Sussex, yeoman 7
4206185 2097710 2097710 defendant Black John saddler 624799 624799 Black, John, of Tysherst, Sussex, saddler 3
4383955 2159340 2159340 defendant Cogger Ambrose   624799 624799 Cogger, Ambrose, of Tysherst, Sussex, "asheayler" 0
4673101 2257230 2257230 defendant Crips John butcher 624799 624799 Crips, John, of tysherst, Sussex, butcher 0
4736290 2276479 2276479 defendant Joce John tiler 624799 624799 Joce, John, of Tysherst, Sussex, tiler 1
4754297 2281720 2281720 defendant atte Wode Robert yeoman 624799 624799 atte Wode, Robert, of Tysherst, Sussex, yeoman 3
4769249 2286361 2286361 defendant Harlesey Robert draper 624799 624799 Harlesey, Robert, of Tysherst, Sussex, draper 2
4782749 2290621 2290621 defendant Stevene Roger husbandman 624799 624799 Stevene, Roger, of Tysherst, Sussex, husbandman 0
4813657 2300378 2300378 defendant Sprynget John husbandman 624799 624799 Sprynget, John, of Tysherst, Sussex, husbandman 2
4813667 2300382 2300382 defendant Sprynget John husbandman 624799 624799 Sprynget, John, of Tysherst, Sussex, husbandman 2
4818899 2301996 2301996 defendant Harlesey Robert tailor 624799 624799 Harlesey, Robert, of Tysherst, Sussex, tailor 3
4840145 2308468 2308468 defendant Bereworde John tanner 624799 624799 Bereworde, John, of Tysherst, Sussex, tanner 0
4840147 2308469 2308469 defendant Bereworde John tanner 624799 624799 Bereworde, John, of Tysherst, Sussex, tanner 0
4927226 2334951 2334951 defendant Stevene Roger husbandman 624799 624799 Stevene, Roger, of Tysherst, sussex, husbandman 0
4939288 2338670 2338670 defendant Cheseman John cooper 624799 624799 Cheseman, John, of Tysherst, Sussex, cooper 1
4978636 2350558 2350558 defendant Stephene Roger husbandman 624799 624799 Stephene, Roger, of Tysherst, Sussex, husbandman 1
5005020 2358366 2358366 defendant Stephene Roger husbandman 624799 624799 Stephene, Roger, of Tysherst, Sussex, husbandman 0
5225542 2423144 2423144 defendant Couper Robert husbandman 624799 624799 (Couper, Robert, of Tysherst, Sussex, husbandman 1
5246561 2429157 2429157 defendant Burkham Richard (legal representative) 624799 624799 Burkham, Richard, of Tysherst, Sussex, husbandman, executors of 0
5248600 2429713 2429713 defendant Couper Thomas husbandman 624799 624799 Couper, Thomas, of Tysherst, Sussex, husbandman 1
5264327 2434598 2434598 defendant Burkham Roger husbandman 624799 624799 (Burkham, Roger, of Tysherst, Sussex, husbandman 1
5281806 2439751 2439751 defendant Ropere William butcher 624799 624799 Ropere, William, of Tysherst, Sussex, butcher 1
5464987 2494440 2494440 defendant Pyg Thomas gent 624799 624799 Pyg, Thomas, of Tysherst, Sussex, gent 0
5551662 2520526 2520526 defendant Saunders William gent 624799 624799 Saunders, William, of Tysherst, Sussex, gent 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);