names

35 rows where place_id = 595739

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3621712 1874331 1874331 plaintiff Ormond John esq 595739 595739 Ormond, John, of Alfreton, esq 0
3641391 1907761 1907761 plaintiff Boghaye Robert   595739 595739 Boghaye, Robert, of Alfreton 0
3644029 1908562 1908562 defendant Watson Thomas husbandman 595739 595739 Watson, Thomas, of Alfreton, husbandman 0
3644030 1908562 1908562 defendant Flynt Robert husbandman 595739 595739 Flynt, Robert, of Alfreton, husbandman 1
3644031 1908562 1908562 defendant Pynder Thomas husbandman 595739 595739 Pynder, Thomas, of Alfreton, husbandman 2
3644032 1908562 1908562 defendant Reyson Thomas husbandman 595739 595739 Reyson, Thomas, of Alfreton, husbandman 3
3644033 1908562 1908562 defendant Watson John husbandman 595739 595739 Watson, John, of Alfreton, husbandman 4
3670767 1916818 1916818 defendant Boghawe Robert husbandman 595739 595739 Boghawe, Robert, of Alfreton, husbandman 0
3972843 2015073 2015073 plaintiff Glossope Thomas   595739 595739 Glossope, Thomas, of Alfreton 0
3996542 2023523 2023523 defendant Glossopp Thomas yeoman 595739 595739 Glossopp, Thomas, of Alfreton, yeoman 0
4149249 2077863 2077863 defendant Derbyshyre Thomas husbandman 595739 595739 Derbyshyre, Thomas, of Alfreton, husbandman 1
4168088 2084327 2084327 defendant Bamforth or Bainforth Thurstan gent 595739 595739 Bamforth or Bainforth, Thurstan, of Alfreton, gent 0
4191564 2092611 2092611 defendant Bamforth or Bainforth Thurstan gent 595739 595739 Bamforth or Bainforth, Thurstan, of Alfreton, gent 0
4194690 2093700 2093700 defendant Derbyshyre Thomas husbandman 595739 595739 Derbyshyre, Thomas, of Alfreton, husbandman 2
4214407 2100545 2100545 defendant Tayler William yeoman 595739 595739 Tayler, William, of Alfreton, yeoman 0
4214408 2100545 2100545 defendant Hobbye Philip yeoman 595739 595739 Hobbye, Philip, of Alfreton, yeoman 1
4225862 2104510 2104510 defendant Taylier William yeoman 595739 595739 Taylier William, of Alfreton, yeoman 0
4300317 2130215 2130215 defendant Hobby Philip yeoman 595739 595739 Hobby, Philip, of Alfreton, yeoman 0
4300327 2130218 2130218 defendant Beighton George yeoman 595739 595739 Beighton, George, of Alfreton, yeoman 1
4300328 2130218 2130218 defendant Somers Thomas yeoman 595739 595739 Somers, Thomas, of Alfreton, yeoman 2
4375681 2156362 2156362 defendant Tatton William huabandman 595739 595739 Tatton, William, of Alfreton, huabandman 2
4386295 2160094 2160094 defendant Elicock or Glicock Thomas tailor 595739 595739 Elicock or Glicock, Thomas, of Alfreton, tailor 0
4390278 2161370 2161370 defendant Boote Roger laborer 595739 595739 Boote, Roger, of Alfreton, laborer 0
4444645 2183303 2183303 defendant Hoggeron William   595739 595739 Hoggeron, William, of Alfreton 2
4613957 2235378 2235378 defendant Misterton John   595739 595739 Misterton, John, of Alfreton 1
4661336 2249368 2249368 defendant Horewode John dyer 595739 595739 Horewode, John, of Alfreton, dyer 1
4721630 2272096 2272096 defendant Fairchild John husbandman 595739 595739 Fairchild, John, of Alfreton, husbandman 0
4730346 2274690 2274690 defendant Schakspere John butcher 595739 595739 Schakspere, John, of Alfreton, butcher 1
4742747 2278384 2278384 defendant Tynet John yeoman 595739 595739 Tynet, John, of Alfreton, yeoman 0
4742748 2278384 2278384 defendant Cartelache Roger husbandman 595739 595739 Cartelache, Roger, of Alfreton, husbandman 1
4742749 2278384 2278384 defendant Chorley Roger de yeoman 595739 595739 Chorley, Roger de, of Alfreton, yeoman 2
4879434 2320498 2320498 defendant Perodes John husbandman 595739 595739 Perodes, John, of Alfreton, husbandman 2
5529018 2513594 2513594 plaintiff Ormond John esq 595739 595739 Ormond, John, of Alfreton, esq 0
5586960 2530949 2530949 defendant Bote Richard husbandman 595739 595739 Bote, Richard, of Alfreton, husbandman 2
5598756 2534488 2534488 defendant Bugbey Robert yeoman 595739 595739 Bugbey, Robert, of Alfreton, yeoman 3

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