names

38 rows where place_id = 603298

✎ 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
3654091 1911542 1911542 defendant Davy Robert husbandman 603298 603298 Davy, Robert, of Orset, husbandman 3
3657089 1912481 1912481 defendant Steward John yeoman 603298 603298 Steward, John, of Orset, yeoman 0
3660827 1913653 1913653 plaintiff Hurt Robert yeoman 603298 603298 Hurt, Robert, of Orset, yeoman 0
3665578 1915185 1915185 defendant Swayne John husbandman 603298 603298 Swayne, John, of Orset, husbandman 0
3665579 1915185 1915185 defendant Gylderson Thomas clerk 603298 603298 Gylderson, Thomas, of Orset, clerk 1
3669668 1916452 1916452 defendant Wryght Richard husbandman 603298 603298 Wryght, Richard, of Orset, husbandman 3
3669673 1916453 1916453 defendant Wryght Richard husbandman 603298 603298 Wryght, Richard, of Orset, husbandman 3
3693492 1924175 1924175 defendant Bryght Richard husbandman 603298 603298 Bryght, Richard, of Orset, husbandman 1
3697268 1925368 1925368 defendant Reynold John butcher 603298 603298 Reynold, John, of Orset, butcher 1
3718964 1932212 1932212 defendant Baryngton Richard   603298 603298 Baryngton, Richard, of Orset, yeoman, administrators of 0
4543935 2214009 2214009 plaintiff Baker William   603298 603298 Baker, William, of Orset 0
4543936 2214009 2214009 defendant Nede Stephen tailor 603298 603298 Nede, Stephen, of Orset, tailor 0
4808137 2298722 2298722 defendant Smyth William ostler or innkeeper 603298 603298 Smyth, William, of Orset, ostler or innkeeper 0
4908362 2329170 2329170 defendant Garnet Robert husbandman 603298 603298 Garnet, Robert, of Orset, husbandman 0
4908365 2329171 2329171 defendant Garnet Robert husbandman 603298 603298 Garnet, Robert, of Orset, husbandman 0
5018349 2362251 2362251 defendant Trewe Richard laborer 603298 603298 Trewe, Richard, of Orset, laborer 4
5075575 2379192 2379192 defendant Leichon Thomas fuller 603298 603298 Leichon, Thomas, of Orset, fuller 2
5133756 2396363 2396363 defendant Pygot John   603298 603298 Pygot, John, of Orset 4
5153100 2402047 2402047 defendant Stevyn William husbandman 603298 603298 Stevyn, William, of Orset, husbandman 1
5170648 2407134 2407134 defendant Stevyn William laborer 603298 603298 Stevyn, William, of Orset, laborer 1
5233506 2425391 2425391 defendant Veere Thomas husbandman 603298 603298 Veere, Thomas, of Orset, husbandman 2
5238401 2426819 2426819 defendant Mok John husbandman 603298 603298 Mok, John, of Orset, husbandman 0
5251128 2430456 2430456 defendant Veer Thomas yeoman 603298 603298 Veer, Thomas, of Orset, yeoman 3
5302857 2445841 2445841 defendant Bryggeman Margaret widow 603298 603298 Bryggeman, Margaret, of Orset, widow 0
5305393 2446624 2446624 defendant Bryggeman Margaret widow 603298 603298 Bryggeman, Margaret, of Orset, widow 0
5347217 2459295 2459295 defendant Gervys John husbandman 603298 603298 Gervys, John, of Orset, husbandman 1
5347220 2459296 2459296 defendant Gervys John husbandman 603298 603298 Gervys, John, of Orset, husbandman 1
5374565 2467651 2467651 defendant Frenke John yeoman 603298 603298 Frenke, John, of Orset, yeoman 0
5374615 2467666 2467666 defendant Frence John yeoman 603298 603298 Frence, John, of Orset, yeoman 0
5381144 2469665 2469665 defendant Wattys John husbandman 603298 603298 Wattys, John, of Orset, husbandman 0
5434465 2485249 2485249 defendant Curteman John   603298 603298 Curteman, John, of Orset 1
5457503 2492142 2492142 defendant Underwode John yeoman 603298 603298 Underwode, John, of Orset, yeoman 0
5472097 2496617 2496617 defendant Hewet John husbandman 603298 603298 Hewet, John, of Orset, husbandman 0
5487568 2501175 2501175 defendant Ynderwode John husbandman 603298 603298 Ynderwode, John, of Orset, husbandman 3
5510848 2508236 2508236 defendant Umfrey William husbandman 603298 603298 Umfrey, William, of Orset, husbandman 4
5554574 2521373 2521373 defendant Rycher Thomas yeoman 603298 603298 Rycher, Thomas, of Orset, yeoman 3
5618249 2549524 2549524 defendant Smyth John   603298 603298 Smyth, John, of Orset 0
5625547 2551933 2551933 defendant Courtman Robert dyer 603298 603298 Courtman, Robert, of Orset, dyer 2

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