names

31 rows where place_id = 606274

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3664665 1914901 1914901 defendant Russell Walter yeoman 606274 606274 Russell, Walter, of North Kylworth, yeoman 2
3664666 1914901 1914901 defendant Bennett Richard yeoman 606274 606274 Bennett, Richard, of North Kylworth, yeoman 3
3664668 1914901 1914901 defendant Haseley William laborer 606274 606274 Haseley, William, of North Kylworth, laborer 5
3739832 1938676 1938676 defendant Skebyngton Thomas   606274 606274 Skebyngton, Thomas, of North Kylworth 0
3739833 1938676 1938676 defendant Robertson Robert clerk 606274 606274 Robertson, Robert, of North Kylworth, clerk 1
3739834 1938676 1938676 defendant Nutte George, junior yeoman 606274 606274 Nutte, George, junior, of North Kylworth, yeoman 2
3739835 1938676 1938676 defendant Greves William tailor 606274 606274 Greves, William, of North Kylworth, tailor 3
3739836 1938676 1938676 defendant Harbre John yeoman 606274 606274 Harbre, John, of North Kylworth, yeoman 4
3739837 1938676 1938676 defendant Benet Richard husbandman 606274 606274 Benet, Richard, of North Kylworth, husbandman 5
3739838 1938676 1938676 defendant More John husbandman 606274 606274 More, John, of North Kylworth, husbandman 6
3739839 1938676 1938676 defendant Aleyn Richard husbandman 606274 606274 Aleyn, Richard, of North Kylworth, husbandman 7
3739840 1938676 1938676 defendant Johnson Thomas husbandman 606274 606274 Johnson, Thomas, of North Kylworth, husbandman 8
3820518 1964302 1964302 defendant Wright Thomas husbandman 606274 606274 Wright, Thomas, of North Kylworth, husbandman 0
3843847 1971614 1971614 defendant Else William yeoman 606274 606274 Else, William, of North Kylworth, yeoman 0
4179306 2088237 2088237 defendant Weale Thomas husbandman 606274 606274 Weale, Thomas, of North Kylworth, husbandman 2
4745301 2279138 2279138 defendant Abbot John husbandman 606274 606274 (Abbot, John, of North Kylworth, husbandman 1
4842521 2309197 2309197 defendant Beby or Bevy John   606274 606274 Beby or Bevy, John, of North Kylworth, parson 0
4888822 2323295 2323295 defendant Warde Margery   606274 606274 Warde, Margery, of North Kylworth, widow of Warde, Thomas, administrators of 0
4888824 2323295 2323295 defendant Warde alias Hyren William husbandman 606274 606274 Warde alias Hyren, William, of North Kylworth, husbandman 2
5003230 2357844 2357844 defendant Tyrlon Thomas   606274 606274 Tyrlon, Thomas, of North Kylworth, servant 2
5003231 2357844 2357844 defendant Wattes William   606274 606274 Wattes, William, of North Kylworth, servant 3
5179177 2409646 2409646 defendant Benet William husbandman 606274 606274 Benet, William, of North Kylworth, husbandman 0
5179178 2409646 2409646 defendant Norman John   606274 606274 Norman, John, of North Kylworth, shoe maker 1
5510502 2508116 2508116 defendant Laye John husbandman 606274 606274 Laye, John, of North Kylworth, husbandman 1
5510503 2508116 2508116 defendant Whyte Richard husbandman 606274 606274 Whyte, Richard, of North Kylworth, husbandman 2
5560973 2523179 2523179 defendant Clerk Thomas clerk 606274 606274 Clerk, Thomas, of North Kylworth, clerk 0
5560974 2523179 2523179 defendant Denham John clerk 606274 606274 Denham, John, of North Kylworth, clerk 1
5569107 2525516 2525516 defendant Thurland William husbandman 606274 606274 Thurland, William, of North Kylworth, husbandman 0
5583955 2530056 2530056 defendant Aston Thomas husbandman 606274 606274 Aston, Thomas, of North Kylworth, husbandman 0
5598112 2534305 2534305 defendant Belgrave William   606274 606274 Belgrave, William, of North Kylworth, esq, administrators of 2
5598114 2534305 2534305 defendant Belgrave Robert gent 606274 606274 Belgrave, Robert, of North Kylworth, gent 4

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