names

94 rows where place_id = 586401

✎ 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
3588624 1864085 1864085 defendant Neve Thomas yeoman 586401 586401 (Neve, Thomas, of Stanfeld, yeoman 3
3588636 1864088 1864088 defendant Neve Thomas yeoman 586401 586401 (Neve, Thomas, of Stanfeld, yeoman 3
3594569 1865931 1865931 defendant Sheltram Richard husbandman 586401 586401 Sheltram, Richard, of Stanfeld, husbandman 0
3604429 1869054 1869054 defendant Smyth John yeoman 586401 586401 Smyth, John, of Stanfeld, yeoman 0
3617956 1873240 1873240 defendant Smyth John yeoman 586401 586401 Smyth, John, of Stanfeld, yeoman 3
3623279 1874807 1874807 defendant Stanfeld Geoffrey gent 586401 586401 Stanfeld, Geoffrey, of Stanfeld, gent 0
3649204 1910140 1910140 defendant Aylmer Richard husbandman 586401 586401 Aylmer, Richard, of Stanfeld, husbandman 1
3664778 1914930 1914930 defendant Flowyr John husbandman 586401 586401 Flowyr, John, of Stanfeld, husbandman 0
3690522 1923200 1923200 defendant Bally John laborer 586401 586401 Bally, John, of Stanfeld, laborer 0
3696103 1925005 1925005 defendant Seymer John husbandman 586401 586401 Seymer, John, of Stanfeld, husbandman 1
3703321 1927313 1927313 defendant Rokewode John (legal representative) 586401 586401 Rokewode, John, of Stanfeld, gent, executrix of 0
3703324 1927314 1927314 defendant Rokewode John (legal representative) 586401 586401 Rokewode, John, of Stanfeld, gent, executrix of 0
3710812 1929697 1929697 defendant Davy William   586401 586401 Davy, William, of Stanfeld, chaplain, son of Nicholas, single man 2
3816013 1962908 1962908 defendant Davy Robert yeoman 586401 586401 Davy, Robert, of Stanfeld, yeoman 1
3853577 1974745 1974745 defendant Fuller John yeoman 586401 586401 Fuller, John, of Stanfeld, yeoman 0
3886681 1985800 1985800 plaintiff Caly Richard   586401 586401 Caly, Richard, of Stanfeld 0
3886682 1985800 1985800 defendant Caly Cecilia (legal representative) 586401 586401 Caly, Cecilia, of Stanfeld, widow, executor of 0
3909491 1993475 1993475 defendant Smyth Alice widow 586401 586401 Smyth, Alice, of Stanfeld, widow 0
3922794 1997930 1997930 defendant Taylour John   586401 586401 Taylour, John, of Stanfeld, cartwright 2
3924856 1998631 1998631 defendant Bygott James gent 586401 586401 Bygott, James, of Stanfeld, gent 0
4079131 2052837 2052837 defendant Dighton Gilbert gent 586401 586401 Dighton, Gilbert, of Stanfeld, gent 0
4090501 2056886 2056886 defendant Haylett Robert yeoman 586401 586401 Haylett, Robert, of Stanfeld, yeoman 0
4094383 2058330 2058330 defendant Dymes William blacksmith 586401 586401 Dymes, William, of Stanfeld, blacksmith 3
4118640 2066959 2066959 defendant Cory Thomas sawyer 586401 586401 Cory, Thomas, of Stanfeld, sawyer 0
4215225 2100820 2100820 defendant Sadler John yeoman 586401 586401 Sadler, John, of Stanfeld, yeoman 0
4452695 2185853 2185853 plaintiff Kirkeby John de   586401 586401 Kirkeby, John de, of Stanfeld, parson 0
4472574 2192092 2192092 defendant Ganton John   586401 586401 Ganton, John, of Stanfeld 1
4477847 2193740 2193740 defendant Fysshere Richard   586401 586401 Fysshere, Richard, of Stanfeld 0
4477848 2193740 2193740 defendant fysshere John   586401 586401 fysshere, John, of Stanfeld 1
4494221 2198883 2198883 defendant Wheteley William   586401 586401 Wheteley, William, of Stanfeld 0
4511837 2204151 2204151 defendant Wheteley William   586401 586401 Wheteley, William, of Stanfeld 0
4525647 2208327 2208327 defendant Wheteley William   586401 586401 Wheteley, William, of Stanfeld 1
4543820 2213964 2213964 plaintiff Rokwode John master 586401 586401 Rokwode, John, of Stanfeld, master 2
4548785 2215556 2215556 defendant Cartere Thomas   586401 586401 Cartere, Thomas, of Stanfeld 1
4548791 2215558 2215558 defendant Cartere Thomas   586401 586401 Cartere, Thomas, of Stanfeld 2
4610567 2234371 2234371 defendant Paxman Geoffrey   586401 586401 Paxman, Geoffrey, of Stanfeld 0
4627596 2239564 2239564 plaintiff Rookewode John esq 586401 586401 Rookewode, John, of Stanfeld, esq 0
4638558 2242813 2242813 defendant Paxman Geoffrey   586401 586401 Paxman, Geoffrey, of Stanfeld 1
4654647 2247333 2247333 defendant Fullere Nicholas fuller 586401 586401 Fullere, Nicholas, of Stanfeld, fuller 0
4661337 2249368 2249368 defendant Crane John cooper 586401 586401 Crane, John, of Stanfeld, cooper 2
4666883 2255371 2255371 defendant Paxman Geoffrey husbandman 586401 586401 Paxman, Geoffrey, of Stanfeld, husbandman 0
4674431 2257614 2257614 defendant Paxman Thomas   586401 586401 Paxman, Thomas, of Stanfeld 3
4674432 2257614 2257614 defendant Greys Thomas husbandman 586401 586401 Greys, Thomas, of Stanfeld, husbandman 4
4736888 2276665 2276665 defendant Wode William yeoman 586401 586401 Wode, William, of Stanfeld, yeoman 1
4751832 2281028 2281028 defendant Totewey Henry clerk 586401 586401 Totewey, Henry, of Stanfeld, clerk 0
4787391 2292124 2292124 defendant Whetele William husbandman 586401 586401 Whetele, William, of Stanfeld, husbandman 0
4788099 2292349 2292349 defendant Paxman Thomas clerk 586401 586401 Paxman, Thomas, of Stanfeld, clerk 0
4831151 2305773 2305773 defendant Paxman Geoffrey yeoman 586401 586401 Paxman, Geoffrey, of Stanfeld, yeoman 1
4839601 2308303 2308303 defendant Macke John husbandman 586401 586401 Macke, John, of Stanfeld, husbandman 0
4860439 2314630 2314630 plaintiff Bocher Thomas   586401 586401 Bocher, Thomas, of Stanfeld 3
4874124 2318848 2318848 defendant Barton Robert husbandman 586401 586401 Barton, Robert, of Stanfeld, husbandman 3
4885012 2322209 2322209 defendant Paxman Geoffrey yeoman 586401 586401 Paxman, Geoffrey, of Stanfeld, yeoman 0
4906413 2328593 2328593 defendant Bocher Thomas yeoman 586401 586401 Bocher, Thomas, of Stanfeld, yeoman 2
5049646 2371518 2371518 defendant Gardener John husbandman 586401 586401 Gardener, John, of Stanfeld, husbandman 0
5056245 2373443 2373443 defendant Pomowre John husbandman 586401 586401 Pomowre, John, of Stanfeld, husbandman 1
5068017 2376936 2376936 defendant Davy William yeoman 586401 586401 Davy, William, of Stanfeld, yeoman 0
5078170 2379957 2379957 defendant Gylmyn John, junior husbandman 586401 586401 Gylmyn, John, junior, of Stanfeld, husbandman 1
5089660 2383350 2383350 defendant Paxman Geoffrey yeoman 586401 586401 Paxman, Geoffrey, of Stanfeld, yeoman 0
5100339 2386544 2386544 defendant Brodde Robert husbandman 586401 586401 Brodde, Robert, of Stanfeld, husbandman 11
5264712 2434721 2434721 plaintiff Smyth John   586401 586401 Smyth, John, of Stanfeld 0
5267256 2435519 2435519 defendant Neve Andrew yeoman 586401 586401 Neve, Andrew, of Stanfeld, yeoman 3
5275355 2437864 2437864 plaintiff Smyth John   586401 586401 Smyth, John, of Stanfeld 0
5282975 2440081 2440081 defendant Davy William yeoman 586401 586401 Davy, William, of Stanfeld, yeoman 2
5297246 2444189 2444189 defendant Halle Robert husbandman 586401 586401 Halle, Robert, of Stanfeld, husbandman 4
5300014 2444968 2444968 defendant Burwell Thomas   586401 586401 Burwell, Thomas, of Stanfeld 0
5316785 2450105 2450105 defendant Davy William yeoman 586401 586401 Davy, William, of Stanfeld, yeoman 2
5324378 2452379 2452379 defendant Taillour John yeoman 586401 586401 Taillour, John, of Stanfeld, yeoman 0
5324382 2452379 2452379 defendant Davy William yeoman 586401 586401 Davy, William, of Stanfeld, yeoman 4
5352518 2460881 2460881 defendant Caly Richard husbandman 586401 586401 Caly, Richard, of Stanfeld, husbandman 0
5353542 2461181 2461181 defendant Neve Thomas laborer 586401 586401 Neve, Thomas, of Stanfeld, laborer 2
5370940 2466496 2466496 defendant Nene Andrew   586401 586401 Nene, Andrew, of Stanfeld, franklin 0
5384752 2470724 2470724 defendant Davy William husbandman 586401 586401 Davy, William, of Stanfeld, husbandman 0
5384753 2470724 2470724 defendant Neve Andrew husbandman 586401 586401 Neve, Andrew, of Stanfeld, husbandman 1
5395604 2473823 2473823 defendant Stanfeld James gent 586401 586401 Stanfeld, James, of Stanfeld, gent 0
5442096 2487554 2487554 defendant Gardener John husbandman 586401 586401 Gardener, John, of Stanfeld, husbandman 4
5448035 2489299 2489299 defendant Stanfeld Ralph yeoman 586401 586401 Stanfeld, Ralph, of Stanfeld, yeoman 2
5448036 2489299 2489299 defendant Sotehill James yeoman 586401 586401 Sotehill, James, of Stanfeld, yeoman 3
5460297 2493017 2493017 defendant Sheltram Richard husbandman 586401 586401 Sheltram, Richard, of Stanfeld, husbandman 0
5461649 2493423 2493423 defendant Stanfeld James gent 586401 586401 Stanfeld, James, of Stanfeld, gent 0
5461653 2493424 2493424 defendant Stanfeld James gent 586401 586401 Stanfeld, James, of Stanfeld, gent 0
5478249 2498521 2498521 defendant Gardener John husbandman 586401 586401 Gardener, John, of Stanfeld, husbandman 4
5490199 2501952 2501952 defendant Gardener John husbandman 586401 586401 Gardener, John, of Stanfeld, husbandman 2
5490562 2502068 2502068 defendant Harryes William clerk 586401 586401 Harryes, William, of Stanfeld, clerk 0
5499701 2504853 2504853 defendant Davy Nicholas yeoman 586401 586401 Davy, Nicholas, of Stanfeld, yeoman 3
5530833 2514158 2514158 defendant Davy Nicholas yeoman 586401 586401 Davy, Nicholas, of Stanfeld, yeoman 1
5539631 2516877 2516877 defendant Saxy Richard yeoman 586401 586401 Saxy, Richard, of Stanfeld, yeoman 0
5550024 2520045 2520045 defendant Davy Nicholas yeoman 586401 586401 Davy, Nicholas, of Stanfeld, yeoman 0
5551842 2520583 2520583 defendant Davy Nicholas yeoman 586401 586401 Davy, Nicholas, of Stanfeld, yeoman 1
5557716 2522209 2522209 defendant Fuller John yeoman 586401 586401 Fuller, John, of Stanfeld, yeoman 1
5557717 2522209 2522209 defendant Bray John yeoman 586401 586401 Bray, John, of Stanfeld, yeoman 2
5562200 2523542 2523542 defendant Davy Nicholas yeoman 586401 586401 Davy, Nicholas, of Stanfeld, yeoman 0
5563395 2523892 2523892 defendant Wake John husbandman 586401 586401 Wake, John, of Stanfeld, husbandman 0
5580779 2529067 2529067 defendant Farwell William husbandman 586401 586401 Farwell, William, of Stanfeld, husbandman 0
5582115 2529475 2529475 defendant Davy Alice widow 586401 586401 Davy, Alice, of Stanfeld, widow 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);