names

39 rows where place_id = 599148

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3635509 1905903 1905903 defendant Dawes William dyer 599148 599148 Dawes, William, of Hitchyn, dyer 0
3642145 1907991 1907991 defendant Daldorn Thomas laborer 599148 599148 Daldorn, Thomas, of Hitchyn, laborer 2
3687317 1922213 1922213 defendant Tyler John glover 599148 599148 Tyler, John, of Hitchyn, glover 1
3804613 1959383 1959383 defendant Smyth Isabel widow 599148 599148 Smyth, Isabel, of Hitchyn, widow 1
3943385 2004801 2004801 plaintiff Andrewe John husbandman 599148 599148 Andrewe, John, of Hitchyn, husbandman 0
3957394 2009650 2009650 defendant Phillippes William yeoman 599148 599148 Phillippes, William, of Hitchyn, yeoman 0
3994979 2022951 2022951 defendant Hewes George shoemaker 599148 599148 (Hewes, George, of Hitchyn, shoemaker 1
4003949 2026182 2026182 plaintiff Pearles John yeoman 599148 599148 Pearles, John, of Hitchyn, yeoman 1
4009361 2028114 2028114 defendant Awdelye William, senior husbandman 599148 599148 Awdelye, William, senior, of Hitchyn, husbandman 0
4036508 2037741 2037741 plaintiff Hurst Edward   599148 599148 Hurst, Edward, of Hitchyn 0
4123899 2068847 2068847 defendant Pearles John butcher 599148 599148 Pearles, John, of Hitchyn, butcher 1
4175517 2086908 2086908 defendant Kempton John yeoman 599148 599148 Kempton, John, of Hitchyn, yeoman 0
4177176 2087489 2087489 defendant Deane Robert tailor 599148 599148 Deane, Robert, of Hitchyn, tailor 0
4177177 2087489 2087489 defendant Lyon Robert tailor 599148 599148 Lyon, Robert, of Hitchyn, tailor 1
4177178 2087489 2087489 defendant Warner Richard tailor 599148 599148 Warner, Richard, of Hitchyn, tailor 2
4189522 2091834 2091834 defendant Barfott Thomas cordwainer 599148 599148 Barfott, Thomas, of Hitchyn, cordwainer 2
4189523 2091834 2091834 defendant Moncke Ralph draper 599148 599148 Moncke, Ralph, of Hitchyn, draper 3
4219150 2102194 2102194 defendant Maynard William, senior yeoman 599148 599148 Maynard, William, senior, of Hitchyn, yeoman 0
4234370 2107559 2107559 defendant Bradlyff Richard cordwainer 599148 599148 Bradlyff, Richard, of Hitchyn, cordwainer 0
4240089 2109658 2109658 defendant Bradley Richard shoemaker 599148 599148 Bradley, Richard, of Hitchyn, shoemaker 0
4240090 2109658 2109658 defendant Kympton William husbandman 599148 599148 Kympton, William, of Hitchyn, husbandman 1
4261249 2116727 2116727 defendant Frenche Thomas yeoman 599148 599148 Frenche, Thomas, of Hitchyn, yeoman 1
4277367 2122007 2122007 defendant Graveley William yeoman 599148 599148 Graveley, William, of Hitchyn, yeoman 2
4277368 2122007 2122007 defendant Hopkyns Gregory chapman 599148 599148 Hopkyns, Gregory, of Hitchyn, chapman 3
4279510 2122752 2122752 defendant Draper John yeoman 599148 599148 Draper, John, of Hitchyn, yeoman 3
4282684 2123847 2123847 defendant Hutchynson John yeoman 599148 599148 Hutchynson, John, of Hitchyn, yeoman 0
4309055 2133324 2133324 defendant Chapman John yeoman 599148 599148 Chapman, John, of Hitchyn, yeoman 0
4333298 2141419 2141419 defendant Hall Edward weaver 599148 599148 Hall, Edward, of Hitchyn, yeoman, weaver 1
4376799 2156773 2156773 defendant Wright William yeoman 599148 599148 Wright, William, of Hitchyn, yeoman 0
4388215 2160689 2160689 defendant Whyte Edward   599148 599148 Whyte, Edward, of Hitchyn, collar maker 0
5039153 2368354 2368354 defendant Boldro John yeoman 599148 599148 (Boldro, John, of Hitchyn, yeoman 1
5039154 2368354 2368354 defendant Preest Thomas yeoman 599148 599148 Preest, Thomas, of Hitchyn, yeoman 2
5039179 2368360 2368360 defendant Boldre John yeoman 599148 599148 Boldre, John, of Hitchyn, yeoman 0
5039180 2368360 2368360 defendant Preest Thomas yeoman 599148 599148 Preest, Thomas, of Hitchyn, yeoman 1
5048024 2371029 2371029 defendant Oflye John butcher 599148 599148 Oflye, John, of Hitchyn, butcher 1
5172442 2407666 2407666 defendant Cooke John laborer 599148 599148 Cooke, John, of Hitchyn, laborer 0
5209243 2418434 2418434 plaintiff Pulter John   599148 599148 Pulter, John, of Hitchyn 2
5273051 2437194 2437194 plaintiff Luke John   599148 599148 Luke, John, of Hitchyn, senior 0
5276285 2438135 2438135 defendant fitz Walter Thomas tilemaker 599148 599148 fitz Walter, Thomas, of Hitchyn, tilemaker 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);