names

101 rows where place_id = 589536

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3597899 1866964 1866964 defendant Crykmay Richard yeoman 589536 589536 Crykmay, Richard, of Shotesham, yeoman 0
3615919 1872618 1872618 defendant Maunnyng William husbandman 589536 589536 Maunnyng, William, of Shotesham, husbandman 4
3622321 1874517 1874517 defendant Whyte Simon gent 589536 589536 Whyte, Simon, of Shotesham, gent 0
3679750 1919735 1919735 defendant Uttyng Stephen husbandman 589536 589536 Uttyng, Stephen, of Shotesham, husbandman 0
3679767 1919737 1919737 defendant Uttyng Stephen husbandman 589536 589536 Uttyng, Stephen, of Shotesham, husbandman 0
3711835 1930016 1930016 defendant Curson Richard husbandman 589536 589536 Curson, Richard, of Shotesham, husbandman 2
3715253 1931056 1931056 defendant Senyor Edmund husbandman 589536 589536 Senyor, Edmund, of Shotesham, husbandman 2
3776195 1950300 1950300 defendant Leman Bartholomew husbandman 589536 589536 Leman, Bartholomew, of Shotesham, husbandman 2
3789928 1954676 1954676 defendant Uttyng Thomas (legal representative) 589536 589536 Uttyng, Thomas, of Shotesham, senior, husbandman, executors of 0
3789931 1954676 1954676 defendant Scolys Robert husbandman 589536 589536 (Scolys, Robert, of Shotesham, husbandman 3
3789932 1954676 1954676 defendant Wulmer Robert husbandman 589536 589536 Wulmer, Robert, of Shotesham, husbandman 4
3798833 1957549 1957549 defendant Braunche John gent 589536 589536 Braunche, John, of Shotesham, gent 0
3809468 1960843 1960843 defendant Leman Bartholomew husbandman 589536 589536 Leman, Bartholomew, of Shotesham, husbandman 1
3950993 2007415 2007415 defendant Carman Vincent yeoman 589536 589536 Carman, Vincent, of Shotesham, yeoman 0
4158958 2081199 2081199 defendant Curson Robert husbandman 589536 589536 Curson, Robert, of Shotesham, husbandman 0
4426616 2173135 2173135 defendant Cade John   589536 589536 Cade, John, of Shotesham 1
4444135 2183143 2183143 defendant Pope Thomas   589536 589536 Pope, Thomas, of Shotesham, son of Henry 0
4448850 2184580 2184580 defendant Goldyng Robert   589536 589536 Goldyng, Robert, of Shotesham 1
4452322 2185714 2185714 defendant Smyth John   589536 589536 Smyth, John, of shotesham 2
4477516 2193637 2193637 defendant Dake Richard   589536 589536 Dake, Richard, of Shotesham 0
4477521 2193638 2193638 defendant Duke Richard   589536 589536 Duke, Richard, of Shotesham 0
4503413 2201637 2201637 defendant Ropere Adam   589536 589536 Ropere, Adam, of Shotesham 0
4557886 2218398 2218398 defendant Melleman Henry   589536 589536 Melleman, Henry, of Shotesham 3
4575276 2223783 2223783 defendant Turnour John   589536 589536 Turnour, John, of Shotesham 1
4607560 2233473 2233473 defendant Hullok Robert   589536 589536 Hullok, Robert, of Shotesham 4
4636972 2242369 2242369 defendant Hullok Robert   589536 589536 Hullok, Robert, of Shotesham 8
4657580 2248259 2248259 defendant Whyte Robert esq 589536 589536 Whyte, Robert, of Shotesham, esq 0
4657581 2248259 2248259 defendant Roke John laborer 589536 589536 Roke, John, of Shotesham, laborer 1
4666517 2251009 2251009 defendant Uttyng Robert laborer 589536 589536 Uttyng, Robert, of Shotesham, laborer 0
4672474 2257041 2257041 defendant White Robert esq 589536 589536 White, Robert, of Shotesham, esq 0
4672480 2257042 2257042 defendant White Robert esq 589536 589536 White, Robert, of Shotesham, esq 0
4737444 2276826 2276826 defendant Hullok Robert husbandman 589536 589536 Hullok, Robert, of Shotesham, husbandman 0
4800293 2296271 2296271 defendant White Robert gent 589536 589536 White, Robert, of Shotesham, gent 0
4901173 2326980 2326980 defendant Costard Richard husbandman 589536 589536 together with Costard, Richard, of Shotesham, husbandman 2
4902486 2327392 2327392 defendant Lymour Robert husbandman 589536 589536 Lymour, Robert, of Shotesham, husbandman 0
4914596 2331083 2331083 defendant Meke John, junior husbandman 589536 589536 Meke, John, junior, of Shotesham, husbandman 0
4914598 2331084 2331084 defendant Wryght John husbandman 589536 589536 Wryght, John, of Shotesham, husbandman 0
4923913 2333919 2333919 defendant V--yng John yeoman 589536 589536 V--yng, John, of Shotesham, yeoman 1
4923915 2333919 2333919 defendant Crokemay John yeoman 589536 589536 Crokemay, John, of Shotesham, yeoman 3
4923917 2333919 2333919 defendant Hose Stephen yeoman 589536 589536 Hose, Stephen, of Shotesham, yeoman 5
4939987 2338894 2338894 defendant Meke John, junior husbandman 589536 589536 Meke, John, junior, of Shotesham, husbandman 0
4948847 2341622 2341622 defendant Lenald Alan yeoman 589536 589536 Lenald, Alan, of Shotesham, yeoman 0
4949163 2341728 2341728 defendant Uttyng John yeoman 589536 589536 Uttyng, John, of Shotesham, yeoman 2
4949164 2341728 2341728 defendant Hose Stephen yeoman 589536 589536 Hose, Stephen, of Shotesham, yeoman 3
4949165 2341728 2341728 defendant Bate Stephen yeoman 589536 589536 Bate, Stephen, of Shotesham, yeoman 4
4949166 2341728 2341728 defendant Crekemay John yeoman 589536 589536 Crekemay, John, of Shotesham, yeoman 5
4949167 2341728 2341728 defendant Crekemay Richard yeoman 589536 589536 Crekemay, Richard, of Shotesham, yeoman 6
4949168 2341728 2341728 defendant Miller Edmund miller 589536 589536 Miller, Edmund, of Shotesham, miller 7
4949843 2341939 2341939 defendant Meke John, junior husbandman 589536 589536 Meke, John, junior, of Shotesham, husbandman 1
4960686 2345154 2345154 defendant Whyte Bartholomew gent 589536 589536 Whyte, Bartholomew, of Shotesham, gent 0
4960689 2345155 2345155 defendant Whyte Bartholomew gent 589536 589536 Whyte, Bartholomew, of Shotesham, gent 0
4965771 2346690 2346690 defendant Meke John husbandman 589536 589536 Meke, John, of Shotesham, husbandman 0
4979480 2350820 2350820 defendant Inys Thomas weaver 589536 589536 Inys, Thomas, of Shotesham, weaver 0
4979481 2350820 2350820 defendant Hyrnyng John laborer 589536 589536 Hyrnyng, John, of Shotesham, laborer 1
4979482 2350820 2350820 defendant Seman John, senior husbandman 589536 589536 Seman, John, senior, of Shotesham, husbandman 2
4979483 2350820 2350820 defendant Penalde Geoffrey husbandman 589536 589536 Penalde, Geoffrey, of Shotesham, husbandman 3
4988095 2353413 2353413 defendant _hene Thomas husbandman 589536 589536 _hene, Thomas, of Shotesham, husbandman 0
5004838 2358313 2358313 defendant Mengy John husbandman 589536 589536 Mengy, John, of Shotesham, husbandman 0
5004888 2358327 2358327 defendant Fleshewer Robert husbandman 589536 589536 Fleshewer, Robert, of Shotesham, husbandman 0
5008641 2359423 2359423 defendant Uttyng John yeoman 589536 589536 Uttyng, John, of Shotesham, yeoman 5
5011679 2360265 2360265 defendant Meke John tailor 589536 589536 Meke, John, of Shotesham, tailor 0
5011680 2360265 2360265 defendant Crekemay Robert husbandman 589536 589536 Crekemay, Robert, of Shotesham, husbandman 1
5015318 2361362 2361362 defendant Shene Thomas husbandman 589536 589536 Shene, Thomas, of Shotesham, husbandman 0
5017036 2361877 2361877 defendant Myngy John yeoman 589536 589536 Myngy, John, of Shotesham, yeoman 3
5029179 2365412 2365412 defendant Costard John husbandman 589536 589536 Costard, John, of Shotesham, husbandman 4
5029180 2365412 2365412 defendant Meke John, junior husbandman 589536 589536 Meke, John, junior, of Shotesham, husbandman 5
5044403 2369956 2369956 defendant Shene Thomas husbandman 589536 589536 Shene, Thomas, of Shotesham, husbandman 5
5047132 2370763 2370763 defendant Uttyng John husbandman 589536 589536 Uttyng, John, of Shotesham, husbandman 4
5058869 2374220 2374220 defendant Sprygolf Stephen husbandman 589536 589536 Sprygolf, Stephen, of Shotesham, husbandman 1
5063823 2375714 2375714 defendant Lymour Thomas yeoman 589536 589536 Lymour, Thomas, of Shotesham, yeoman 0
5063824 2375714 2375714 defendant Uttyng John yeoman 589536 589536 Uttyng, John, of Shotesham, yeoman 1
5075183 2379074 2379074 defendant Howes Richard husbandman 589536 589536 Howes, Richard, of Shotesham, husbandman 1
5081331 2380923 2380923 defendant Lymour Thomas yeoman 589536 589536 Lymour, Thomas, of Shotesham, yeoman 0
5083365 2381520 2381520 defendant Bate Stephen husbandman 589536 589536 Bate, Stephen, of Shotesham, husbandman 0
5083366 2381520 2381520 defendant Billern William yeoman 589536 589536 Billern, William, of Shotesham, yeoman 1
5083367 2381520 2381520 defendant Shene Thomas husbandman 589536 589536 Shene, Thomas, of Shotesham, husbandman 2
5091468 2383892 2383892 defendant White Bartholomew esq 589536 589536 White, Bartholomew, of Shotesham, esq 0
5100341 2386544 2386544 defendant Howys Richard husbandman 589536 589536 Howys, Richard, of Shotesham, husbandman 13
5112954 2390183 2390183 defendant Lymour Thomas yeoman 589536 589536 Lymour, Thomas, of Shotesham, yeoman 1
5112955 2390183 2390183 defendant Uttyng John yeoman 589536 589536 Uttyng, John, of Shotesham, yeoman 2
5135751 2396968 2396968 defendant Shene Robert husbandman 589536 589536 Shene, Robert, of Shotesham, husbandman 1
5135752 2396968 2396968 defendant Crykemeye John husbandman 589536 589536 Crykemeye, John, of Shotesham, husbandman 2
5137183 2397389 2397389 defendant (illegible) (illegible) esq 589536 589536 ----, ----, of Shotesham, esq 0
5158353 2403567 2403567 defendant Bate Stephen husbandman 589536 589536 Bate, Stephen, of Shotesham, husbandman 0
5158358 2403568 2403568 defendant Bate Stephen husbandman 589536 589536 Bate, Stephen, of Shotesham, husbandman 0
5158363 2403569 2403569 defendant Bate Stephen husbandman 589536 589536 Bate, Stephen, of Shotesham, husbandman 0
5207811 2418026 2418026 defendant Shene Robert husbandman 589536 589536 Shene, Robert, of Shotesham, husbandman 1
5207812 2418026 2418026 defendant Krykemay John husbandman 589536 589536 Krykemay, John, of Shotesham, husbandman 2
5232833 2425187 2425187 defendant Uttyng Thomas husbandman 589536 589536 Uttyng, Thomas, of Shotesham, husbandman 0
5232837 2425187 2425187 defendant Playford Thomas husbandman 589536 589536 Playford, Thomas, of Shotesham, husbandman 4
5232838 2425187 2425187 defendant Charete Geoffrey husbandman 589536 589536 Charete, Geoffrey, of Shotesham, husbandman 5
5271471 2436749 2436749 defendant Lymore Thomas yeoman 589536 589536 Lymore, Thomas, of Shotesham, yeoman 3
5308368 2447540 2447540 defendant Mengy Thomas husbandman 589536 589536 Mengy, Thomas, of Shotesham, husbandman 0
5326064 2452889 2452889 defendant Howys Richard husbandman 589536 589536 Howys, Richard, of Shotesham, husbandman 1
5400335 2475171 2475171 defendant Roper Richard chaplain 589536 589536 Roper, Richard, of Shotesham, chaplain 7
5426756 2482947 2482947 defendant Wygour Robert yeoman 589536 589536 Wygour, Robert, of Shotesham, yeoman 0
5428532 2483459 2483459 defendant Roper Richard chaplain 589536 589536 Roper, Richard, of Shotesham, chaplain 7
5428567 2483467 2483467 defendant Roper Richard chaplain 589536 589536 Roper, Richard, of Shotesham, chaplain 5
5512173 2508670 2508670 defendant Howys Stephen yeoman 589536 589536 Howys, Stephen, of Shotesham, yeoman 2
5512174 2508670 2508670 defendant Howys Richard yeoman 589536 589536 Howys, Richard, of Shotesham, yeoman 3

Next page

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