names

44 rows where place_id = 606921

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3666965 1915612 1915612 defendant Darlyng John miller & inn holder 606921 606921 Darlyng, John, of Adderbury, miller & inn holder 0
3681789 1920404 1920404 defendant Smyth Richard yeoman 606921 606921 Smyth, Richard, of Adderbury, yeoman 0
3731032 1935934 1935934 plaintiff Busterd John gent 606921 606921 Busterd, John, of Adderbury, gent 0
3738081 1938128 1938128 defendant Graunger John husbandman 606921 606921 Graunger, John, of Adderbury, or of Kyrtlyngton, husbandman 0
3803942 1959148 1959148 defendant Colles William   606921 606921 Colles, William, of Adderbury, wheelwright 0
3829988 1967275 1967275 defendant Pebworth Gilbert husbandman 606921 606921 Pebworth, Gilbert, of Adderbury, husbandman 0
3832345 1968033 1968033 defendant Kynston Richard husbandman 606921 606921 Kynston, Richard, of Adderbury, husbandman 0
3837390 1969604 1969604 defendant Henne Thomas yeoman 606921 606921 Henne, Thomas, of Adderbury, yeoman 0
3870610 1980413 1980413 defendant Davy James tailor 606921 606921 Davy, James, of Adderbury, tailor 0
3870611 1980413 1980413 defendant Petworth Gilbert organplayer 606921 606921 Petworth, Gilbert, of Adderbury, organplayer 1
3912262 1994431 1994431 defendant Turnar Thomas husbandman 606921 606921 Turnar, Thomas, of Adderbury, husbandman 0
3912263 1994431 1994431 defendant Degull Henry husbandman 606921 606921 Degull, Henry, of Adderbury, husbandman 1
3929370 2000169 2000169 plaintiff Butler Roger   606921 606921 Butler, Roger, of Adderbury, inn holder 0
4018153 2031215 2031215 defendant Heath Henry yeoman 606921 606921 Heath, Henry, of Adderbury, yeoman 0
4341170 2144184 2144184 defendant Barnard Thomas husbandman 606921 606921 Barnard, Thomas, of Adderbury, husbandman 0
4341171 2144184 2144184 defendant Davies Hugh husbandman 606921 606921 Davies, Hugh, of Adderbury, husbandman 1
4356732 2149584 2149584 defendant Barnard Thomas husbandman 606921 606921 Barnard, Thomas, of Adderbury, husbandman 1
5021266 2363120 2363120 defendant Chadworth Thomas husbandman 606921 606921 Chadworth, Thomas, of Adderbury, husbandman 0
5021267 2363120 2363120 defendant Lovell John husbandman 606921 606921 Lovell, John, of Adderbury, husbandman 1
5021268 2363120 2363120 defendant Child John husbandman 606921 606921 Child, John, of Adderbury, husbandman 2
5029238 2365433 2365433 defendant atte Welle John   606921 606921 atte Welle, John, of Adderbury, servant 0
5029240 2365433 2365433 defendant Lynde Richard yeoman 606921 606921 Lynde, Richard, of Adderbury, yeoman 2
5065964 2376343 2376343 defendant Lunde John carpenter 606921 606921 Lunde, John, of Adderbury, carpenter 2
5065965 2376343 2376343 defendant Grene William miller 606921 606921 Grene, William, of Adderbury, miller 3
5121894 2392839 2392839 defendant Clere Richard husbandman 606921 606921 Clere, Richard, of Adderbury, husbandman 2
5161504 2404464 2404464 defendant Taberer William husbandman 606921 606921 Taberer, William, of Adderbury, husbandman 0
5161505 2404464 2404464 defendant Symmys Joan   606921 606921 Symmys, Joan, of Adderbury, servant 1
5175884 2408628 2408628 defendant Taberer William husbandman 606921 606921 Taberer, William, of Adderbury, husbandman 0
5175885 2408628 2408628 defendant Symmys Joan   606921 606921 Symmys, Joan, of Adderbury, servant 1
5197592 2415032 2415032 defendant Taverer William husbandman 606921 606921 Taverer, William, of Adderbury, husbandman 0
5197593 2415032 2415032 defendant Symmys Joan   606921 606921 Symmys, Joan, of Adderbury, servant 1
5273849 2437431 2437431 defendant Boys Walter yeoman 606921 606921 Boys, Walter, of Adderbury, yeoman 0
5273850 2437431 2437431 defendant Taberer William husbandman 606921 606921 Taberer, William, of Adderbury, husbandman 1
5286825 2441154 2441154 defendant Taberer William husbandman 606921 606921 Taberer, William, of Adderbury, husbandman 1
5286831 2441155 2441155 defendant Taberer William husbandman 606921 606921 Taberer, William, of Adderbury, husbandman 1
5290383 2442191 2442191 defendant Boys Walter yeoman 606921 606921 Boys, Walter, of Adderbury, yeoman 0
5290384 2442191 2442191 defendant Taberer William husbandman 606921 606921 Taberer, William, of Adderbury, husbandman 1
5328347 2453552 2453552 defendant Boyes Walter yeoman 606921 606921 Boyes, Walter, of Adderbury, yeoman 0
5374734 2467696 2467696 defendant Whyte John husbandman 606921 606921 Whyte, John, of Adderbury, husbandman 0
5510013 2507972 2507972 defendant Grene John butcher 606921 606921 Grene, John, of Adderbury, butcher 0
5515702 2509756 2509756 defendant Mathewe Richard husbandman 606921 606921 Mathewe, Richard, of Adderbury, husbandman 0
5590575 2532022 2532022 plaintiff Smyth Thomas   606921 606921 Smyth, Thomas, of Adderbury 0
5596041 2533674 2533674 defendant Smyth William chapman 606921 606921 Smyth, William, of Adderbury, chapman 1
5605595 2536631 2536631 defendant Smyth William chapman 606921 606921 Smyth, William, of Adderbury, chapman 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);