names

44 rows where place_id = 593783

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3613283 1871805 1871805 defendant Spakeman Thurstan smith 593783 593783 Spakeman, Thurstan, of Matlok, smith 1
3620467 1873978 1873978 defendant Smyth Richard yeoman 593783 593783 Smyth, Richard, of Matlok, yeoman 1
3668563 1916124 1916124 defendant Ragge James   593783 593783 Ragge, James, of Matlok, "smylter" 1
3773355 1949380 1949380 defendant Else James yeoman 593783 593783 Else, James, of Matlok, yeoman 0
3773357 1949380 1949380 defendant Tagge William laborer 593783 593783 Tagge, William, of Matlok, laborer 2
3773358 1949380 1949380 defendant Hill William laborer 593783 593783 Hill, William, of Matlok, laborer 3
3808884 1960658 1960658 defendant Downes Edmund husbandman 593783 593783 Downes, Edmund, of Matlok, husbandman 4
4480033 2194425 2194425 defendant Steple Richard   593783 593783 Steple, Richard, of Matlok, parson 0
4500315 2200722 2200722 defendant Smyth John   593783 593783 Smyth, John, of Matlok 6
4530834 2209933 2209933 defendant Pyllesley Thomas de   593783 593783 Pyllesley, Thomas de, of Matlok 0
4575528 2223854 2223854 defendant Broun John   593783 593783 Broun, John, of Matlok 0
4610299 2234306 2234306 defendant Coterell Stephen   593783 593783 Coterell, Stephen, of Matlok 2
4621790 2237799 2237799 defendant More John   593783 593783 More, John, of Matlok 0
4641596 2243643 2243643 defendant Bland Thomas   593783 593783 Bland, Thomas, of Matlok 0
4651516 2246478 2246478 defendant More John yeoman 593783 593783 More, John, of Matlok, yeoman 3
4684940 2260883 2260883 defendant More John yeoman 593783 593783 More, John, of Matlok, yeoman 1
4920669 2332979 2332979 defendant Boune Edward husbandman 593783 593783 Boune, Edward, of Matlok, husbandman 1
5128154 2394709 2394709 defendant Henstok Richard husbandman 593783 593783 Henstok, Richard, of Matlok, husbandman 3
5249781 2430056 2430056 defendant Storde William   593783 593783 Storde, William, of Matlok 0
5378629 2468899 2468899 defendant Madder Edward laborer 593783 593783 Madder, Edward, of Matlok, laborer 0
5378631 2468900 2468900 defendant Mader Edward laborer 593783 593783 Mader, Edward, of Matlok, laborer 0
5528989 2513587 2513587 defendant Smyth Henry husbandman 593783 593783 Smyth, Henry, of Matlok, husbandman 0
5528990 2513587 2513587 defendant Flynt Henry husbandman 593783 593783 Flynt, Henry, of Matlok, husbandman 1
5528991 2513587 2513587 defendant Flynte James husbandman 593783 593783 Flynte, James, of Matlok, husbandman 2
5528995 2513588 2513588 defendant Spencer Nicholas husbandman 593783 593783 Spencer, Nicholas, of Matlok, husbandman 0
5528997 2513589 2513589 defendant Spencer Nicholas husbandman 593783 593783 Spencer, Nicholas, of Matlok, husbandman 0
5528999 2513590 2513590 defendant Suppar Thomas laborer 593783 593783 Suppar, Thomas, of Matlok, laborer 0
5529000 2513590 2513590 defendant Key Robert laborer 593783 593783 Key, Robert, of Matlok, laborer 1
5529002 2513590 2513590 defendant Wyllymot John laborer 593783 593783 Wyllymot, John, of Matlok, laborer 3
5529003 2513590 2513590 defendant Suppar John laborer 593783 593783 Suppar, John, of Matlok, laborer 4
5529005 2513591 2513591 defendant Supper Thomas laborer 593783 593783 Supper, Thomas, of Matlok, laborer 0
5529006 2513591 2513591 defendant Kay Robert laborer 593783 593783 Kay, Robert, of Matlok, laborer 1
5529008 2513591 2513591 defendant Tippyng John laborer 593783 593783 Tippyng, John, of Matlok, laborer 3
5529009 2513591 2513591 defendant Willymot John laborer 593783 593783 Willymot, John, of Matlok, laborer 4
5529010 2513591 2513591 defendant Suppar John laborer 593783 593783 Suppar, John, of Matlok, laborer 5
5543132 2517971 2517971 defendant Godenogh Richard laborer 593783 593783 Godenogh, Richard, of Matlok, laborer 1
5543135 2517971 2517971 defendant Brewode Thomas laborer 593783 593783 Brewode, Thomas, of Matlok, laborer 4
5543138 2517971 2517971 defendant Nicholas Richard laborer 593783 593783 Nicholas, Richard, of Matlok, laborer 7
5589822 2531805 2531805 defendant Wodde Charles miner 593783 593783 Wodde, Charles, of Matlok, miner 5
5589823 2531805 2531805 defendant Flent Roger miner 593783 593783 Flent, Roger, of Matlok, miner 6
5589825 2531805 2531805 defendant Broune Roger miner 593783 593783 Broune, Roger, of Matlok, miner 8
5589826 2531805 2531805 defendant Flynte James miner 593783 593783 Flynte, James, of Matlok, miner 9
5589827 2531805 2531805 defendant Spencer Nicholas miner 593783 593783 Spencer, Nicholas, of Matlok, miner 10
5589828 2531805 2531805 defendant Deyne Robert miner 593783 593783 Deyne, Robert, of Matlok, miner 11

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