names

45 rows where place_id = 610111

✎ 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
3681998 1920475 1920475 defendant Welles William tanner 610111 610111 Welles, William, of Hoke, tanner 0
3816827 1963170 1963170 defendant Raner John husbandman 610111 610111 Raner, John, of Hoke, husbandman 0
3816828 1963170 1963170 defendant Stephynson William husbandman 610111 610111 Stephynson, William, of Hoke, husbandman 1
4525088 2208189 2208189 defendant Dounyng John   610111 610111 Dounyng, John, of Hoke 1
4553721 2217086 2217086 defendant Lynche John   610111 610111 Lynche, John, of Hoke 0
4608796 2233855 2233855 defendant Merveyl William   610111 610111 Merveyl, William, of Hoke 0
4660555 2249126 2249126 plaintiff Dene William   610111 610111 Dene, William, of Hoke 0
4662801 2249824 2249824 defendant Stone William husbandman 610111 610111 Stone, William, of Hoke, husbandman 0
4670574 2256473 2256473 defendant Bocher Richard butcher 610111 610111 Bocher, Richard, of Hoke, butcher 0
4703740 2266550 2266550 defendant Uttyng Richard husbandman 610111 610111 Uttyng, Richard, of Hoke, husbandman 0
4728766 2274234 2274234 defendant Chaunceller William esq 610111 610111 Chaunceller, William, of Hoke, esq 0
4809051 2299007 2299007 plaintiff Dene William   610111 610111 Dene, William, of Hoke, on his own account 0
4855321 2313016 2313016 defendant Stokfeld John yeoman 610111 610111 Stokfeld, John, of Hoke, yeoman 0
4892837 2324490 2324490 defendant atte Hoke John husbandman 610111 610111 atte Hoke, John, of Hoke, husbandman 2
4915190 2331257 2331257 defendant atte Hethe Michael (legal representative) 610111 610111 atte Hethe, Michael, of Hoke Mortymer, executors of 2
4927251 2334962 2334962 defendant Bacheler William husbandman 610111 610111 Bacheler, William, of Hoke Mortemer, husbandman 0
4955082 2343472 2343472 defendant Hygon John hosier 610111 610111 Hygon, John, of Hoke Mortymer, hosier 0
4960540 2345120 2345120 defendant Bacheler Robert laborer 610111 610111 Bacheler, Robert, of Hoke, laborer 0
4960541 2345120 2345120 defendant Broun Thomas husbandman 610111 610111 Broun, Thomas, of Hoke, husbandman 1
4979356 2350787 2350787 defendant Mably John husbandman 610111 610111 Mably, John, of Hoke, husbandman 0
5025412 2364329 2364329 defendant Couper Thomas yeoman 610111 610111 Couper, Thomas, of Hoke Mortemer, yeoman 0
5092653 2384231 2384231 defendant Hachard John husbandman 610111 610111 Hachard, John, of Hoke, husbandman 0
5115109 2390839 2390839 defendant Pipar Henry shipman 610111 610111 Pipar, Henry, of Hoke Mortemer, shipman 0
5117436 2391532 2391532 defendant Goodale Richard yeoman 610111 610111 Goodale, Richard, of Hoke Mortemer, yeoman 0
5187140 2411966 2411966 defendant Warde William yeoman 610111 610111 Warde, William, of Hoke, yeoman 1
5187141 2411966 2411966 defendant Fysshe Thomas smith 610111 610111 Fysshe, Thomas, of Hoke, smith 2
5187148 2411967 2411967 defendant Warde William yeoman 610111 610111 Warde, William, of Hoke, yeoman 1
5187149 2411967 2411967 defendant Fysshe Thomas yeoman 610111 610111 Fysshe, Thomas, of Hoke, yeoman 2
5197692 2415066 2415066 defendant Cove or Coke John weaver 610111 610111 Cove or Coke, John, of Hoke Mortymer, weaver 0
5201344 2416151 2416151 defendant Sexcy Richard merchant 610111 610111 Sexcy, Richard, of Hoke Mortemer, merchant 0
5205513 2417360 2417360 defendant Warde William yeoman 610111 610111 Warde, William, of Hoke, yeoman 1
5205514 2417360 2417360 defendant Fyssher Thomas yeoman 610111 610111 Fyssher, Thomas, of Hoke, yeoman 2
5224388 2422809 2422809 defendant Mauncell John esq 610111 610111 Mauncell, John, of Hoke, esq 0
5224391 2422810 2422810 defendant Mauncell John esq 610111 610111 Mauncell, John, of Hoke, esq 0
5244051 2428449 2428449 defendant Saxy Richard merchant 610111 610111 Saxy, Richard, of Hoke Mortymer, merchant 0
5244928 2428689 2428689 defendant Browene John husbandman 610111 610111 Browene, John, of Hoke Mortemer, husbandman 1
5244931 2428690 2428690 defendant Browene John husbandman 610111 610111 Browene, John, of Hoke Mortemer, husbandman 1
5325789 2452795 2452795 defendant Sexi Richard husbandman 610111 610111 Sexi, Richard, of Hoke, husbandman 0
5328228 2453517 2453517 defendant Cristian Robert tailor 610111 610111 Cristian, Robert, of Hoke Mortemer, tailor 0
5351143 2460459 2460459 defendant Gaythorne John husbandman 610111 610111 Gaythorne, John, of Hoke, husbandman 0
5356387 2462064 2462064 defendant Knyght Henry merchant 610111 610111 Knyght, Henry, of Hoke Mortymer, merchant 1
5574868 2527221 2527221 defendant Dawe Richard husbandman 610111 610111 Dawe, Richard, of Hoke, husbandman 0
5614948 2548472 2548472 defendant Lyndewey Walter   610111 610111 Lyndewey, Walter, of Hoke 0
5614949 2548472 2548472 defendant Dunnyng John   610111 610111 Dunnyng, John, of Hoke 1
5625380 2551875 2551875 defendant Montagu John shipman 610111 610111 Montagu, John, of Hoke Mortemer, shipman 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);