names

46 rows where place_id = 590749

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3602183 1868349 1868349 defendant Stokes Thomas esq 590749 590749 Stokes, Thomas, of Kegworth, Leics, esq 0
3654401 1911637 1911637 defendant Stokes Robert gent 590749 590749 Stokes, Robert, of Kegworth, Leics, gent 0
3663340 1914458 1914458 defendant Butteler John butcher 590749 590749 Butteler, John, of Kegworth, Leics, butcher 0
3667677 1915836 1915836 defendant Eyre George gent 590749 590749 Eyre, George, of Kegworth, Leics, gent 0
3667679 1915837 1915837 defendant Lee John yeoman 590749 590749 Lee, John, of Kegworth, Leics, yeoman 0
3769769 1948198 1948198 defendant Stokys Robert gent 590749 590749 Stokys, Robert, of Kegworth, Leics, gent 0
3922630 1997885 1997885 defendant Palmer Robert gent 590749 590749 Palmer, Robert, of Kegworth, Leics, gent 0
3944895 2005309 2005309 defendant Palmer Robert gent 590749 590749 Palmer, Robert, of Kegworth, Leics, gent 0
3953893 2008432 2008432 defendant Alleyn John yeoman 590749 590749 Alleyn, John, of Kegworth, Leics, yeoman 0
3958141 2009920 2009920 defendant Palmer Robert gent 590749 590749 Palmer, Robert, of Kegworth, Leics, gent 0
3995890 2023280 2023280 defendant Palmer Robert gent 590749 590749 Palmer, Robert, of Kegworth, Leics, gent 0
4006824 2027221 2027221 defendant Palmer Robert gent 590749 590749 Palmer, Robert, of Kegworth, Leics, gent 0
4282902 2123919 2123919 defendant Stone William gent 590749 590749 Stone, William, of Kegworth, Leics, gent 0
4340098 2143802 2143802 defendant Meade Humphrey butcher 590749 590749 Meade, Humphrey, of Kegworth, Leics, butcher 2
4363434 2151997 2151997 defendant Meade Humphrey butcher 590749 590749 Meade, Humphrey, of Kegworth, Leics, butcher 1
4700245 2265493 2265493 defendant Walker John husbandman 590749 590749 Walker, John, of Kegworth, Leics, husbandman 1
4702704 2266247 2266247 defendant Walker John husbandman 590749 590749 Walker, John, of Kegworth, Leics, husbandman 0
4718819 2271230 2271230 defendant Notyngham John esq 590749 590749 Notyngham, John, of Kegworth, Leics, esq 1
4944714 2340333 2340333 defendant Brygge John gent 590749 590749 Brygge, John, of Kegworth, Leics, gent 1
4967846 2347327 2347327 defendant Brigge John yeoman 590749 590749 Brigge, John, of Kegworth, Leics, yeoman 4
4993907 2355047 2355047 defendant Smyth Robert husbandman 590749 590749 Smyth, Robert, of Kegworth, Leics, husbandman 0
4996826 2355907 2355907 defendant Brugge John gent 590749 590749 Brugge, John, of Kegworth, Leics, gent 1
4999910 2356851 2356851 defendant Brugge John gent 590749 590749 Brugge, John, of Kegworth, Leics, gent 1
5023576 2363806 2363806 defendant Brigge John gent 590749 590749 Brigge, John, of Kegworth, Leics, gent 1
5032573 2366411 2366411 defendant Brugge John gent 590749 590749 Brugge, John, of Kegworth, Leics, gent 1
5032576 2366412 2366412 defendant Brugge John gent 590749 590749 Brugge, John, of Kegworth, Leics, gent 1
5032579 2366413 2366413 defendant Brugge John gent 590749 590749 Brugge, John, of Kegworth, Leics, gent 1
5032582 2366414 2366414 defendant Brugge John gent 590749 590749 Brugge, John, of Kegworth, Leics, gent 1
5033792 2366765 2366765 defendant Brigge john gent 590749 590749 Brigge, john, of Kegworth, Leics, gent 1
5044371 2369949 2369949 defendant Brigge John gent 590749 590749 Brigge, John, of Kegworth, Leics, gent 3
5044377 2369950 2369950 defendant Brigge John gent 590749 590749 Brigge, John, of Kegworth, Leics, gent 3
5067325 2376735 2376735 defendant Bridge John gent 590749 590749 Bridge, John, of Kegworth, Leics, gent 1
5138902 2397879 2397879 defendant Brigge John gent 590749 590749 Brigge, John, of Kegworth, Leics, gent 0
5152162 2401769 2401769 defendant Stotusbury John gent 590749 590749 Stotusbury, John, of Kegworth, Leics, gent 3
5159804 2403969 2403969 defendant Brugge John gent 590749 590749 Brugge, John, of Kegworth, Leics, gent 0
5174786 2408325 2408325 defendant Brugge John gent 590749 590749 Brugge, John, of Kegworth, Leics, gent 0
5188614 2412390 2412390 defendant Stokley John yeoman 590749 590749 Stokley, John, of Kegworth, Leics, yeoman 2
5220303 2421633 2421633 defendant Stokley John yeoman 590749 590749 Stokley, John, of Kegworth, Leics, yeoman 1
5298795 2444625 2444625 defendant Turner John husbandman 590749 590749 Turner, John, of Kegworth, Leics, husbandman 1
5298796 2444625 2444625 defendant Barton Robert husbandman 590749 590749 Barton, Robert, of Kegworth, Leics, husbandman 2
5378892 2468986 2468986 defendant Etewall alias Fyssher William husbandman 590749 590749 Etewall alias Fyssher, William, of Kegworth, Leics, husbandman 1
5407512 2477220 2477220 defendant Etwall William husbandman 590749 590749 Etwall, William, of Kegworth, Leics, husbandman 1
5420760 2481134 2481134 defendant Etwall William husbandman 590749 590749 Etwall, William, of Kegworth, Leics, husbandman 1
5439698 2486813 2486813 defendant Etwall William husbandman 590749 590749 Etwall, William, of Kegworth, Leics, husbandman 1
5439703 2486814 2486814 defendant Etwall William husbandman 590749 590749 Etwall, William, of Kegworth, Leics, husbandman 1
5544987 2518540 2518540 defendant Stokys Robert gent 590749 590749 Stokys, Robert, of Kegworth, Leics, gent 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);