names

26 rows where place_id = 609178

✎ 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
3677332 1918960 1918960 defendant Arnold Christopher husbandman 609178 609178 Arnold, Christopher, of Wellyngore, husbandman 0
3677333 1918960 1918960 defendant Martyn Thomas husbandman 609178 609178 Martyn, Thomas, of Wellyngore, husbandman 1
3677334 1918960 1918960 defendant Blesby Thomas husbandman 609178 609178 Blesby, Thomas, of Wellyngore, husbandman 2
3677335 1918960 1918960 defendant Barton William husbandman 609178 609178 Barton, William, of Wellyngore, husbandman 3
3677336 1918960 1918960 defendant Medylbroke John husbandman 609178 609178 Medylbroke, John, of Wellyngore, husbandman 4
3677337 1918960 1918960 defendant Neyp or Neyper Thomas husbandman 609178 609178 Neyp or Neyper, Thomas, of Wellyngore, husbandman 5
3693008 1924017 1924017 defendant Arnenold Christopher husbandman 609178 609178 Arnenold, Christopher, of Wellyngore, husbandman 0
3693009 1924017 1924017 defendant Marten Thomas husbandman 609178 609178 Marten, Thomas, of Wellyngore, husbandman 1
3693010 1924017 1924017 defendant Blesby Thomas husbandman 609178 609178 Blesby, Thomas, of Wellyngore, husbandman 2
3693011 1924017 1924017 defendant Barton William husbandman 609178 609178 Barton, William, of Wellyngore, husbandman 3
3693012 1924017 1924017 defendant Medylbroke John husbandman 609178 609178 Medylbroke, John, of Wellyngore, husbandman 4
3693014 1924018 1924018 defendant Neyper or Neyp Thomas husbandman 609178 609178 Neyper or Neyp, Thomas, of Wellyngore, husbandman 0
3720864 1932819 1932819 defendant Tompson Christopher yeoman 609178 609178 Tompson, Christopher, of Wellyngore, yeoman 0
3912288 1994440 1994440 defendant Clerke William husbandman 609178 609178 Clerke, William, of Wellyngore, husbandman 1
4584480 2226561 2226561 defendant Jelee Richard   609178 609178 Jelee, Richard, of Wellyngore 0
4584483 2226562 2226562 defendant Molet John   609178 609178 Molet, John, of Wellyngore 0
4650844 2246266 2246266 defendant Sely William   609178 609178 Sely, William, of Wellyngore 2
4751538 2280935 2280935 defendant Whassyngburgh Robert husbandman 609178 609178 Whassyngburgh, Robert, of Wellyngore, husbandman 1
4961893 2345510 2345510 defendant Martyn Martin husbandman 609178 609178 Martyn, Martin, of Wellyngore, husbandman 0
4987834 2353327 2353327 defendant Chevyn Robert husbandman 609178 609178 Chevyn, Robert, of Wellyngore, husbandman 0
4988453 2353507 2353507 defendant Jonson John   609178 609178 Jonson, John, of Wellyngore, lutenist or lute player 0
5007582 2359115 2359115 defendant Mart_ Martin husbandman 609178 609178 Mart_, Martin, of Wellyngore, husbandman 1
5022512 2363484 2363484 defendant White Ralph husbandman 609178 609178 White, Ralph, of Wellyngore, husbandman 1
5023510 2363785 2363785 defendant Martyn Martin husbandman 609178 609178 Martyn, Martin, of Wellyngore, husbandman 1
5541223 2517375 2517375 defendant Stokys John husbandman 609178 609178 Stokys, John, of Wellyngore, husbandman 4
5576081 2527581 2527581 defendant Lane Thomas husbandman 609178 609178 Lane, Thomas, of Wellyngore, husbandman 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);