names

29 rows where place_id = 588518

✎ 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
3594795 1865999 1865999 defendant Wylson John chaplain 588518 588518 Wylson, John, of Aldryngton, chaplain 0
3594828 1866012 1866012 defendant Wilson John chaplain 588518 588518 Wilson, John, of Aldryngton, chaplain 0
3594832 1866013 1866013 defendant Wilson John clerk 588518 588518 Wilson, John, of Aldryngton, clerk 0
3594838 1866015 1866015 defendant Wylson John chaplain 588518 588518 Wylson, John, of Aldryngton, chaplain 0
3594842 1866016 1866016 defendant Wylson John clerk 588518 588518 Wylson, John, of Aldryngton, clerk 0
3594949 1866049 1866049 plaintiff Garnon Margery widow 588518 588518 Garnon, Margery, of Aldryngton, widow 1
3595962 1866368 1866368 defendant Moyne John husbandman 588518 588518 Moyne, John, of Aldryngton, husbandman 0
3977239 2016609 2016609 plaintiff Lede Richard yeoman 588518 588518 Lede, Richard, of Aldryngton, yeoman 0
4097305 2059355 2059355 defendant Brusbye Henry husbandman 588518 588518 Brusbye, Henry, of Aldryngton, husbandman 1
4558563 2218632 2218632 defendant Baker John clerk 588518 588518 Baker, John, of Aldryngton, clerk 0
4583323 2226205 2226205 plaintiff Fowe John   588518 588518 Fowe, John, of Aldryngton 0
4584685 2226630 2226630 defendant Baillyf William   588518 588518 Baillyf, William, of Aldryngton 0
4584687 2226631 2226631 defendant London John   588518 588518 London, John, of Aldryngton 0
4601288 2231638 2231638 defendant Sprot Simon   588518 588518 Sprot, Simon, of Aldryngton 0
4641961 2243753 2243753 defendant Averey John   588518 588518 Averey, John, of Aldryngton 0
4679089 2259065 2259065 defendant Brakpol John, senior husbandman 588518 588518 Brakpol, John, senior, of Aldryngton, husbandman 0
4681231 2259756 2259756 defendant Milner John husbandman 588518 588518 Milner, John, of Aldryngton, husbandman 1
4738299 2277073 2277073 defendant Smyth John husbandman 588518 588518 Smyth, John, of Aldryngton, husbandman 0
4783295 2290796 2290796 plaintiff Davy John   588518 588518 Davy, John, of Aldryngton 0
4783296 2290796 2290796 defendant Clere Henry husbandman 588518 588518 Clere, Henry, of Aldryngton, husbandman 0
4794492 2294416 2294416 defendant Crosse John chapman 588518 588518 Crosse, John, of Aldryngton, chapman 0
4922991 2333610 2333610 defendant Wodeman John yeoman 588518 588518 Wodeman, John, of Aldryngton, yeoman 0
4936427 2337782 2337782 defendant Ballet Simon shipman 588518 588518 Ballet, Simon, of Aldryngton, shipman 0
5025277 2364287 2364287 defendant Brase Robert clerk 588518 588518 Brase, Robert, of Aldryngton, clerk 2
5025286 2364289 2364289 defendant Brase Robert clerk 588518 588518 Brase, Robert, of Aldryngton, clerk 2
5085052 2382039 2382039 plaintiff Gore William   588518 588518 Gore, William, of Aldryngton 0
5085068 2382040 2382040 plaintiff Gore William   588518 588518 Gore, William, of Aldryngton 0
5088065 2382885 2382885 defendant Gore William gent 588518 588518 Gore, William, of Aldryngton, gent 0
5342566 2457875 2457875 defendant Stoughton Robert laborer 588518 588518 Stoughton, Robert, of Aldryngton, laborer 2

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