names

116 rows where place_id = 586170

✎ 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
3588074 1863919 1863919 defendant Alpe Robert husbandman 586170 586170 Alpe, Robert, of Tybenham, husbandman 1
3594878 1866028 1866028 defendant Payn John yeoman 586170 586170 Payn, John, of Tybenham, yeoman 1
3594879 1866028 1866028 defendant Heyward John yeoman 586170 586170 Heyward, John, of Tybenham, yeoman 2
3607307 1869947 1869947 defendant Crewe William husbandman 586170 586170 Crewe, William, of Tybenham, husbandman 0
3627882 1903578 1903578 plaintiff Browne William butcher 586170 586170 Browne, William, of Tybenham, butcher 0
3641695 1907859 1907859 defendant Brette Robert husbandman 586170 586170 Brette, Robert, of Tybenham, husbandman 1
3667978 1915925 1915925 defendant Holte Simon husbandman 586170 586170 Holte, Simon, of Tybenham, husbandman 0
3667979 1915925 1915925 defendant Cowper Adrian husbandman 586170 586170 Cowper, Adrian, of Tybenham, husbandman 1
3671118 1916934 1916934 defendant Adamys Richard husbandman 586170 586170 Adamys, Richard, of Tybenham, husbandman 0
3677324 1918957 1918957 defendant Alpe Thomas turner 586170 586170 Alpe, Thomas, of Tybenham, turner 1
3677757 1919091 1919091 defendant Alpe Thomas husbandman 586170 586170 Alpe, Thomas, of Tybenham, husbandman 0
3687156 1922158 1922158 defendant Adams Richard yeoman 586170 586170 Adams, Richard, of Tybenham, yeoman 0
3687423 1922244 1922244 defendant Alpe Thomas husbandman 586170 586170 Alpe, Thomas, of Tybenham, husbandman 0
3719618 1932403 1932403 defendant Adams Richard husbandman 586170 586170 Adams, Richard, of Tybenham, husbandman 1
3729043 1935333 1935333 defendant Taylour John husbandman 586170 586170 Taylour, John, of Tybenham, husbandman 0
3736752 1937745 1937745 defendant Colman William husbandman 586170 586170 Colman, William, of Tybenham, husbandman 0
3736753 1937745 1937745 defendant Colman Robert husbandman 586170 586170 Colman, Robert, of Tybenham, husbandman 1
3741977 1939359 1939359 defendant Alpe Thomas turner 586170 586170 Alpe, Thomas, of Tybenham, turner 0
3742015 1939371 1939371 defendant Alpe Thomas turner 586170 586170 Alpe, Thomas, of Tybenham, turner 0
3784072 1952799 1952799 defendant Taylour Adam husbandman 586170 586170 Taylour, Adam, of Tybenham, husbandman 1
3785280 1953183 1953183 defendant Colman Robert yeoman 586170 586170 Colman, Robert, of Tybenham, yeoman 2
3789277 1954464 1954464 defendant Taylour John husbandman 586170 586170 Taylour, John, of Tybenham, husbandman 0
3789279 1954464 1954464 defendant Feke Joan widow 586170 586170 Feke, Joan, of Tybenham, widow 2
3803537 1959013 1959013 defendant Colman Robert butcher 586170 586170 Colman, Robert, of Tybenham, butcher 0
3803539 1959014 1959014 defendant Colman Robert yeoman 586170 586170 Colman, Robert, of Tybenham, yeoman 0
3842831 1971292 1971292 defendant Sewall Richard husbandman 586170 586170 Sewall, Richard, of Tybenham, husbandman 0
3842834 1971292 1971292 defendant Walker Edmund husbandman 586170 586170 Walker, Edmund, of Tybenham, husbandman 3
3854311 1974986 1974986 plaintiff Taylour Robert   586170 586170 Taylour, Robert, of Tybenham 0
3856993 1975821 1975821 defendant Plate Gregory clerk 586170 586170 Plate, Gregory, of Tybenham, clerk 1
3871569 1980732 1980732 defendant Adams Richard husbandman 586170 586170 Adams, Richard, of Tybenham, husbandman 1
3872477 1981019 1981019 defendant Bawdewyn Richard husbandman 586170 586170 Bawdewyn, Richard, of Tybenham, husbandman 3
3873834 1981468 1981468 defendant Colman Robert yeoman 586170 586170 Colman, Robert, of Tybenham, yeoman 0
3873836 1981468 1981468 defendant Brette John husbandman 586170 586170 Brette, John, of Tybenham, husbandman 2
3876146 1982269 1982269 defendant Hyrn William husbandman 586170 586170 Hyrn, William, of Tybenham, husbandman 2
3878701 1983124 1983124 defendant Colman Robert butcher 586170 586170 Colman, Robert, of Tybenham, butcher 1
3882401 1984380 1984380 defendant Platte Gregory clerk 586170 586170 Platte, Gregory, of Tybenham, clerk 0
3882402 1984380 1984380 defendant Taylour Adam husbandman 586170 586170 Taylour, Adam, of Tybenham, husbandman 1
3902497 1991066 1991066 defendant Edwarde James weaver 586170 586170 Edwarde, James, of Tybenham, weaver 0
3913951 1995012 1995012 defendant Colman Robert husbandman 586170 586170 Colman, Robert, of Tybenham, husbandman 1
3967530 2013277 2013277 plaintiff Buxton John gent 586170 586170 Buxton, John, of Tybenham, gent 0
4009498 2028162 2028162 defendant Dabbe Bartholomew husbandman 586170 586170 Dabbe, Bartholomew, of Tybenham, husbandman 2
4009499 2028162 2028162 defendant Howell Ralph husbandman 586170 586170 Howell, Ralph, of Tybenham, husbandman 3
4096220 2058975 2058975 defendant Cory Robert gent 586170 586170 Cory, Robert, of Tybenham, gent 2
4149012 2077772 2077772 defendant Thunder John husbandman 586170 586170 Thunder, John, of Tybenham, husbandman 0
4152271 2078905 2078905 defendant Edwardes Thomas yeoman 586170 586170 Edwardes, Thomas, of Tybenham, yeoman 3
4215423 2100890 2100890 defendant Carman Samuel yeoman 586170 586170 Carman, Samuel, of Tybenham, yeoman 0
4215424 2100890 2100890 defendant Seman William yeoman 586170 586170 Seman, William, of Tybenham, yeoman 1
4220374 2102631 2102631 defendant Grene Thomas yeoman 586170 586170 Grene, Thomas, of Tybenham, yeoman 2
4232481 2106867 2106867 defendant Wylbye Henry husbandman 586170 586170 Wylbye, Henry, of Tybenham, husbandman 2
4251079 2113340 2113340 defendant Syngleton John yeoman 586170 586170 Syngleton, John, of Tybenham, yeoman 0
4260509 2116483 2116483 defendant Swayne Thomas husbandman 586170 586170 Swayne, Thomas, of Tybenham, husbandman 1
4284015 2124326 2124326 defendant Badson Marion widow 586170 586170 Badson, Marion, of Tybenham, widow 0
4288184 2125822 2125822 defendant Goodwyn Elizabeth widow 586170 586170 Goodwyn, Elizabeth, of Tybenham, widow 0
4338841 2143339 2143339 defendant Cawston Edmund husbandman 586170 586170 Cawston, Edmund, of Tybenham, husbandman 0
4338842 2143339 2143339 defendant Cawston Walter husbandman 586170 586170 Cawston, Walter, of Tybenham, husbandman 1
4349683 2147155 2147155 defendant Thunder Thomas husbandman 586170 586170 Thunder, Thomas, of Tybenham, husbandman 2
4351308 2147708 2147708 defendant Brett Thomas yeoman 586170 586170 Brett, Thomas, of Tybenham, yeoman 0
4367813 2153539 2153539 defendant Edward William yeoman 586170 586170 Edward, William, of Tybenham, yeoman 0
4389524 2161123 2161123 defendant Carman Samuel yeoman 586170 586170 Carman, Samuel, of Tybenham, yeoman 1
4401913 2165236 2165236 defendant Thunder Thomas husbandman 586170 586170 Thunder, Thomas, of Tybenham, husbandman 2
4437455 2176464 2176464 defendant Gerard John   586170 586170 Gerard, John, of Tybenham, vicar 0
4473326 2192317 2192317 defendant Staham John   586170 586170 Staham, John, of Tybenham 0
4545956 2214671 2214671 plaintiff Bouye or Bonye William   586170 586170 Bouye or Bonye, William, of Tybenham 0
4554939 2217473 2217473 defendant Baroun Robert   586170 586170 Baroun, Robert, of Tybenham 0
4575965 2223976 2223976 defendant Baroun Robert   586170 586170 Baroun, Robert, of Tybenham 1
4581250 2225603 2225603 defendant Cartere Thomas   586170 586170 Cartere, Thomas, of Tybenham 1
4592528 2229015 2229015 defendant Launde Robert   586170 586170 Launde, Robert, of Tybenham 4
4602371 2231958 2231958 defendant Launde Robert   586170 586170 Launde, Robert, of Tybenham 4
4653625 2247060 2247060 defendant Thorn Thomas chapman 586170 586170 Thorn, Thomas, of Tybenham, chapman 4
4656436 2247908 2247908 plaintiff Cartere Thomas   586170 586170 Cartere, Thomas, of Tybenham 0
4745861 2279293 2279293 defendant Clerk Guy husbandman 586170 586170 Clerk, Guy, of Tybenham, husbandman 1
4787333 2292109 2292109 defendant Clerk Guy husbandman 586170 586170 Clerk, Guy, of Tybenham, husbandman 0
4897777 2325970 2325970 defendant Spencer John husbandman 586170 586170 Spencer, John, of Tybenham, husbandman 0
5055120 2373104 2373104 defendant Colman Thomas husbandman 586170 586170 Colman, Thomas, of Tybenham, husbandman 0
5136136 2397081 2397081 defendant Welles John husbandman 586170 586170 Welles, John, of Tybenham, husbandman 0
5156449 2403040 2403040 defendant Melles John husbandman 586170 586170 Melles, John, of Tybenham, husbandman 0
5164672 2405402 2405402 defendant Tasman Thomas clerk 586170 586170 Tasman, Thomas, of Tybenham, clerk 0
5213375 2419641 2419641 plaintiff Crowe John, junior   586170 586170 Crowe, John, junior, of Tybenham 1
5213376 2419641 2419641 plaintiff Taylour Adam   586170 586170 Taylour, Adam, of Tybenham 2
5252605 2430931 2430931 defendant Coteler William husbandman 586170 586170 Coteler, William, of Tybenham, husbandman 0
5269621 2436224 2436224 defendant Doo John husbandman 586170 586170 Doo, John, of Tybenham, husbandman 0
5272240 2436954 2436954 defendant Horn John husbandman 586170 586170 Horn, John, of Tybenham, husbandman 5
5274975 2437763 2437763 defendant Clerk William husbandman 586170 586170 Clerk, William, of Tybenham, husbandman 2
5279242 2439028 2439028 defendant Byrle John husbandman 586170 586170 Byrle, John, of Tybenham, husbandman 2
5286808 2441149 2441149 defendant Horn John husbandman 586170 586170 Horn, John, of Tybenham, husbandman 5
5292776 2442884 2442884 defendant Clerk William husbandman 586170 586170 Clerk, William, of Tybenham, husbandman 2
5292781 2442885 2442885 defendant Clerk William husbandman 586170 586170 Clerk, William, of Tybenham, husbandman 1
5299889 2444933 2444933 defendant Byrle John husbandman 586170 586170 Byrle, John, of Tybenham, husbandman 5
5320400 2451185 2451185 defendant Payn John yeoman 586170 586170 Payn, John, of Tybenham, yeoman 0
5320710 2451288 2451288 defendant Payn John yeoman 586170 586170 Payn, John, of Tybenham, yeoman 3
5320716 2451289 2451289 defendant Payn John yeoman 586170 586170 Payn, John, of Tybenham, yeoman 3
5325286 2452651 2452651 defendant Clerk William husbandman 586170 586170 Clerk, William, of Tybenham, husbandman 0
5340751 2457307 2457307 plaintiff Payne John   586170 586170 Payne, John, of Tybenham 0
5340754 2457308 2457308 plaintiff Payne John   586170 586170 Payne, John, of Tybenham 0
5354913 2461611 2461611 defendant Payne John yeoman 586170 586170 Payne, John, of Tybenham, yeoman 0
5386144 2471105 2471105 plaintiff Payn John   586170 586170 (Payn, John, of Tybenham 1
5400336 2475171 2475171 defendant Brill John husbandman 586170 586170 Brill, John, of Tybenham, husbandman 8
5409996 2477959 2477959 defendant Payn John yeoman 586170 586170 Payn, John, of Tybenham, yeoman 3
5413331 2478917 2478917 defendant Brill John husbandman 586170 586170 Brill, John, of Tybenham, husbandman 8
5423695 2482050 2482050 defendant Payn John yeoman 586170 586170 Payn, John, of Tybenham, 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);