names

52 rows where place_id = 591944

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3606070 1869565 1869565 defendant Grevell or Grenell John esq 591944 591944 Grevell or Grenell, John, of Drayton, Oxon, esq 0
3606552 1869721 1869721 defendant Grevell or Grenell John esq 591944 591944 Grevell or Grenell, John, of Drayton, Oxon, esq 0
3606554 1869722 1869722 defendant Grevell or Grenell John esq 591944 591944 Grevell or Grenell, John, of Drayton, Oxon, esq 0
3649458 1910221 1910221 defendant Grevell John gent 591944 591944 Grevell, John, of Drayton, Oxon, gent 2
3690561 1923214 1923214 defendant Grevyll John esq 591944 591944 Grevyll, John, of Drayton, Oxon, esq 0
3752340 1942656 1942656 defendant Grevyle John esq 591944 591944 Grevyle, John, of Drayton, Oxon, esq 0
3755337 1943624 1943624 defendant Grevile John esq 591944 591944 Grevile, John, of Drayton, Oxon, esq 3
3755342 1943625 1943625 defendant Grevyle John esq 591944 591944 Grevyle, John, of Drayton, Oxon, esq 3
3755347 1943626 1943626 defendant Grevile John esq 591944 591944 Grevile, John, of Drayton, Oxon, esq 3
3791444 1955161 1955161 defendant Grevyle John esq 591944 591944 Grevyle, John, of Drayton, Oxon, esq 1
3797611 1957149 1957149 defendant Grevill John esq 591944 591944 Grevill, John, of Drayton, Oxon, esq 0
3815770 1962851 1962851 defendant Davys John yeoman 591944 591944 Davys, John, of Drayton, Oxon, yeoman 0
3815772 1962852 1962852 defendant Davys John yeoman 591944 591944 Davys, John, of Drayton, Oxon, yeoman 0
3817988 1963544 1963544 defendant Grevill John esq 591944 591944 Grevill, John, of Drayton, Oxon, esq 1
3835555 1969059 1969059 defendant Grevell Fulk esq 591944 591944 Grevell, Fulk, of Drayton, Oxon, esq 0
4035901 2037513 2037513 defendant Webbe Thomas yeoman 591944 591944 Webbe, Thomas, of Drayton, Oxon, yeoman 0
4035905 2037514 2037514 defendant Webbe Thomas yeoman 591944 591944 Webbe, Thomas, of Drayton, Oxon, yeoman 0
4042615 2039830 2039830 plaintiff Paulinge Richard yeoman 591944 591944 Paulinge, Richard, of Drayton, Oxon, yeoman 0
4116773 2066297 2066297 defendant Webbe Thomas yeoman 591944 591944 Webbe, Thomas, of Drayton, Oxon, yeoman 1
4188053 2091323 2091323 defendant Tayler Edward husbandman 591944 591944 (Tayler, Edward, of Drayton, Oxon, husbandman 3
4296856 2128975 2128975 defendant Taylor Henry husbandman 591944 591944 Taylor, Henry, of Drayton, Oxon, husbandman 0
4300633 2130324 2130324 defendant Spycer Richard gent 591944 591944 Spycer, Richard, of Drayton, Oxon, gent 0
4618292 2236731 2236731 plaintiff Hampton Thomas   591944 591944 Hampton, Thomas, of Drayton, Oxon 0
4741028 2277887 2277887 defendant Grevyll Thomas esq 591944 591944 Grevyll, Thomas, of Drayton, Oxon, esq 2
4741032 2277888 2277888 defendant Grevyll Thomas esq 591944 591944 Grevyll, Thomas, of Drayton, Oxon, esq 2
4779811 2289681 2289681 defendant Davy Richard husbandman 591944 591944 Davy, Richard, of Drayton, Oxon, husbandman 0
4915953 2331486 2331486 defendant Adkyns John   591944 591944 Adkyns, John, of Drayton, Oxon 0
4987001 2353055 2353055 defendant Buldry John husbandman 591944 591944 Buldry, John, of Drayton, Oxon, husbandman 2
5215816 2420351 2420351 defendant Idlee Peter esq 591944 591944 Idlee, Peter, of Drayton, Oxon, esq 0
5221272 2421917 2421917 defendant Idele Peter gent 591944 591944 Idele, Peter, of Drayton, Dorchester, Oxon, gent 2
5221276 2421918 2421918 defendant Idle Peter esq 591944 591944 Idle, Peter, of Drayton, Oxon, esq 0
5221278 2421919 2421919 defendant Idle Peter esq 591944 591944 Idle, Peter, of Drayton, Oxon, esq 0
5240144 2427320 2427320 plaintiff Idele Peter esq 591944 591944 Idele, Peter, of Drayton, Oxon, esq 0
5240146 2427321 2427321 plaintiff Idele Peter esq 591944 591944 Idele, Peter, of Drayton, Oxon, esq 0
5240148 2427322 2427322 plaintiff Idele Peter esq 591944 591944 Idele, Peter, of Drayton, Oxon, esq 0
5240150 2427323 2427323 plaintiff Idele Peter esq 591944 591944 Idele, Peter, of Drayton, Oxon, esq 0
5240152 2427324 2427324 plaintiff Idele Peter esq 591944 591944 Idele, Peter, of Drayton, Oxon, esq 0
5244156 2428484 2428484 plaintiff Pele Peter esq 591944 591944 Pele, Peter, of Drayton, Oxon, esq 0
5276690 2438263 2438263 defendant Idley Peter esq 591944 591944 Idley, Peter, of Drayton, Oxon, esq 1
5276695 2438264 2438264 defendant Idley Peter esq 591944 591944 Idley, Peter, of Drayton, Oxon, esq 1
5289692 2441988 2441988 defendant Boys John miller 591944 591944 Boys, John, of Drayton, Oxon, miller 0
5302101 2445584 2445584 defendant Idle Peter gent 591944 591944 Idle, Peter, of Drayton by Dorchester, Oxon, gent 0
5349864 2460092 2460092 defendant Grevell or Grenell John esq 591944 591944 Grevell or Grenell, John, of Drayton, Oxon, esq 1
5367547 2465498 2465498 defendant Grevyle John esq 591944 591944 Grevyle, John, of Drayton, Oxon, esq 0
5408766 2477579 2477579 defendant Grevell John esq 591944 591944 Grevell, John, of Drayton, Oxon, esq 0
5408768 2477580 2477580 defendant Grevell John esq 591944 591944 Grevell, John, of Drayton, Oxon, esq 0
5422040 2481530 2481530 defendant Grevell John esq 591944 591944 Grevell, John, of Drayton, Oxon, esq 0
5422042 2481531 2481531 defendant Grevell John esq 591944 591944 Grevell, John, of Drayton, Oxon, esq 0
5422044 2481532 2481532 defendant Grevell John esq 591944 591944 Grevell, John, of Drayton, Oxon, esq 0
5491608 2502379 2502379 defendant Grevyll John esq 591944 591944 Grevyll, John, of Drayton, Oxon, esq 2
5495940 2503681 2503681 defendant Grevell John gent 591944 591944 Grevell, John, of Drayton, Oxon, gent 2
5500958 2505236 2505236 defendant Grevyll John esq 591944 591944 Grevyll, John, of Drayton, Oxon, esq 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);