names

31 rows where place_id = 587356

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3591173 1864862 1864862 defendant Harward John husbandman 587356 587356 Harward, John, of Arlyngton, husbandman 0
3591174 1864862 1864862 defendant Taillour Thomas husbandman 587356 587356 Taillour, Thomas, of Arlyngton, husbandman 1
3679368 1919610 1919610 defendant Fote Edward yeoman 587356 587356 Fote, Edward, of Arlyngton, yeoman 0
3679369 1919610 1919610 defendant Chamberleyn Thomas yeoman 587356 587356 Chamberleyn, Thomas, of Arlyngton, yeoman 1
3693110 1924053 1924053 defendant Banes Joan widow 587356 587356 Banes, Joan, of Arlyngton, widow 1
3754415 1943338 1943338 defendant Tukkey John husbandman 587356 587356 Tukkey, John, of Arlyngton, husbandman 0
3754416 1943338 1943338 defendant Kyrke William husbandman 587356 587356 Kyrke, William, of Arlyngton, husbandman 1
3764009 1946386 1946386 defendant Cole Edmund husbandman 587356 587356 Cole, Edmund, of Arlyngton, husbandman 0
3827601 1966494 1966494 defendant A Chambir Leonard husbandman 587356 587356 A Chambir, Leonard, of Arlyngton, husbandman 0
3846901 1972568 1972568 defendant Gyles John husbandman 587356 587356 Gyles, John, of Arlyngton, husbandman 0
3848641 1973158 1973158 defendant Parker Richard husbandman 587356 587356 Parker, Richard, of Arlyngton, husbandman 1
3871073 1980578 1980578 defendant Webbe Richard husbandman 587356 587356 Webbe, Richard, of Arlyngton, husbandman 0
3871074 1980578 1980578 defendant Hiches Roger husbandman 587356 587356 Hiches, Roger, of Arlyngton, husbandman 1
3965565 2012569 2012569 defendant Kellyngton John husbandman 587356 587356 Kellyngton, John, of Arlyngton, husbandman 0
3965567 2012570 2012570 defendant Kellyngton John husbandman 587356 587356 Kellyngton, John, of Arlyngton, husbandman 0
4018696 2031420 2031420 defendant Wyrgar John husbandman 587356 587356 Wyrgar, John, of Arlyngton, husbandman 0
4019016 2031536 2031536 defendant Kynge Richard husbandman 587356 587356 Kynge, Richard, of Arlyngton, husbandman 1
4148965 2077759 2077759 defendant Rotes Thomas gent 587356 587356 Rotes, Thomas, of Arlyngton, gent 0
4177558 2087626 2087626 defendant Quested Stephen yeoman 587356 587356 Quested, Stephen, of Arlyngton, yeoman 0
4177560 2087627 2087627 defendant Quested Stephen yeoman 587356 587356 Quested, Stephen, of Arlyngton, yeoman 0
4177561 2087627 2087627 defendant Danyell Thomas husbandman 587356 587356 Danyell, Thomas, of Arlyngton, husbandman 1
4178041 2087790 2087790 defendant Rotes or Rootes Thomas gent 587356 587356 Rotes or Rootes, Thomas, of Arlyngton, gent 1
4184219 2089976 2089976 defendant Horsman Robert husbandman 587356 587356 Horsman, Robert, of Arlyngton, husbandman 2
4186034 2090604 2090604 defendant Root Thomas gent 587356 587356 Root, Thomas, of Arlyngton, gent 0
4187848 2091250 2091250 defendant Earle Christopher carpenter 587356 587356 Earle, Christopher, of Arlyngton, carpenter 1
4187849 2091250 2091250 defendant Herryett John tailor 587356 587356 Herryett, John, of Arlyngton, tailor 2
4228645 2105502 2105502 defendant Stroker Anthony yeoman 587356 587356 Stroker, Anthony, of Arlyngton, yeoman 0
4367325 2153369 2153369 defendant Danyell Thomas husbandman 587356 587356 Danyell, Thomas, of Arlyngton, husbandman 2
5293331 2443030 2443030 defendant Spryng Robert, senior yeoman 587356 587356 Spryng, Robert, senior, of Arlyngton, yeoman 0
5455916 2491677 2491677 defendant Hore John   587356 587356 Hore, John, of Arlyngton 0
5565744 2524573 2524573 defendant Parker Robert yeoman 587356 587356 Parker, Robert, of Arlyngton, yeoman 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);