names

116 rows where place_id = 587789

✎ 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
3592440 1865250 1865250 defendant Walwen John gent 587789 587789 Walwen, John, of Longford, gent 0
3609127 1870512 1870512 defendant Beggeworth Walter husbandman 587789 587789 Beggeworth, Walter, of Longford, husbandman 0
3611436 1871253 1871253 defendant Wylde Nicholas clerk 587789 587789 Wylde, Nicholas, of Longford, clerk 0
3611437 1871253 1871253 defendant Wykde Robert draper 587789 587789 Wykde, Robert, of Longford, draper 1
3611438 1871253 1871253 defendant Wylde Margaret widow 587789 587789 Wylde, Margaret, of Longford, widow 2
3611814 1871356 1871356 defendant Hathysyche Ralph husbandman 587789 587789 Hathysyche, Ralph, of Longford, husbandman 3
3644226 1908625 1908625 defendant Cockys Richard husbandman 587789 587789 Cockys, Richard, of Longford, husbandman 0
3671628 1917113 1917113 defendant Cokkys John   587789 587789 Cokkys, John, of Longford 0
3738214 1938164 1938164 defendant Bordeley Thomas, senior husbandman 587789 587789 Bordeley, Thomas, senior, of Longford, husbandman 3
3739262 1938500 1938500 defendant Gadogan John laborer 587789 587789 Gadogan, John, of Longford, laborer 3
3739267 1938500 1938500 defendant Tyler John tiler 587789 587789 Tyler, John, of Longford, tiler 8
3739268 1938500 1938500 defendant Webley John laborer 587789 587789 Webley, John, of Longford, laborer 9
3739269 1938500 1938500 defendant Sereaunt William laborer 587789 587789 Sereaunt, William, of Longford, laborer 10
3739274 1938501 1938501 defendant Gadogan John laborer 587789 587789 Gadogan, John, of Longford, laborer 3
3739279 1938501 1938501 defendant Tyler John tiler 587789 587789 Tyler, John, of Longford, tiler 8
3739280 1938501 1938501 defendant Webley John laborer 587789 587789 Webley, John, of Longford, laborer 9
3739281 1938501 1938501 defendant Sereaunt William laborer 587789 587789 Sereaunt, William, of Longford, laborer 10
3770868 1948575 1948575 defendant Walles Edward husbandman 587789 587789 Walles, Edward, of Longford, husbandman 1
3849391 1973406 1973406 defendant Down Thomas yeoman 587789 587789 Down, Thomas, of Longford, yeoman 3
3850321 1973688 1973688 plaintiff Methwold William gent 587789 587789 Methwold, William, of Longford, gent 0
3852547 1974405 1974405 defendant Etley Thomas husbandman 587789 587789 Etley, Thomas, of Longford, husbandman 2
3852548 1974405 1974405 defendant Cox John husbandman 587789 587789 Cox, John, of Longford, husbandman 3
3885082 1985271 1985271 defendant Mylner Margaret widow 587789 587789 Mylner, Margaret, of Longford, widow 0
3949712 2006977 2006977 defendant Drynkwater Richard laborer 587789 587789 Drynkwater, Richard, of Longford, laborer 1
3975689 2016056 2016056 defendant Drynkewater William husbandman 587789 587789 Drynkewater, William, of Longford, husbandman 0
3991157 2021595 2021595 defendant Tayler alias Barker John (legal representative) 587789 587789 Tayler alias Barker, John, of Longford, gent, principal registrar of Gloucester, executors of 0
3991158 2021595 2021595 defendant Hans or Haus Richard gent 587789 587789 Hans or Haus, Richard, of Longford, gent 1
4024965 2033592 2033592 defendant Tayler alias Barker John (legal representative) 587789 587789 Tayler alias Barker, John, of Longford, gent, principal register of city of Gloucester, executors of 0
4024966 2033592 2033592 defendant Hans or Haus Richard gent 587789 587789 (Hans or Haus, Richard, of Longford, gent 1
4099994 2060325 2060325 defendant Wallewyn Thomas gent 587789 587789 Wallewyn, Thomas, of Longford, gent 0
4130414 2071191 2071191 defendant Wallewyn Eleanor widow 587789 587789 Wallewyn, Eleanor, of Longford, widow 0
4170303 2085106 2085106 defendant Cugley Richard yeoman 587789 587789 Cugley, Richard, of Longford, yeoman 0
4177390 2087564 2087564 defendant Cuggley Richard yeoman 587789 587789 Cuggley, Richard, of Longford, yeoman 0
4179363 2088255 2088255 defendant Jobson Thomas Derbs, clerk 587789 587789 Jobson Thomas, of Longford, Derbs, clerk 0
4214373 2100534 2100534 defendant Cuerton Thomas (legal representative) 587789 587789 Cuerton, Thomas, of Longford, yeoman, administratrix of 0
4237524 2108715 2108715 defendant Bysshopp Maurice husbandman 587789 587789 Bysshopp, Maurice, of Longford, husbandman 0
4289528 2126319 2126319 defendant Veale John gent 587789 587789 Veale, John, of Longford, gent 0
4289529 2126319 2126319 defendant Holland John yeoman 587789 587789 Holland, John, of Longford, yeoman 1
4289530 2126319 2126319 defendant Coxe John husbandman 587789 587789 Coxe, John, of Longford, husbandman 2
4289531 2126319 2126319 defendant Veale Edward yeoman 587789 587789 Veale, Edward, of Longford, yeoman 3
4316876 2136019 2136019 defendant Coxe John yeoman 587789 587789 Coxe, John, of Longford, yeoman 0
4340307 2143874 2143874 defendant Capenor John husbandman 587789 587789 Capenor, John, of Longford, husbandman 0
4376062 2156501 2156501 defendant Hyett Thomas husbandman 587789 587789 Hyett, Thomas, of Longford, husbandman 0
4402120 2165298 2165298 defendant Capeyor John husbandman 587789 587789 Capeyor, John, of Longford, husbandman 0
4402121 2165298 2165298 defendant Perkyns Richard husbandman 587789 587789 Perkyns, Richard, of Longford, husbandman 1
4402122 2165298 2165298 defendant Wylse John husbandman 587789 587789 Wylse, John, of Longford, husbandman 2
4652948 2246852 2246852 defendant Woderowe John yeoman 587789 587789 Woderowe, John, of Longford, yeoman 0
4811846 2299818 2299818 defendant Yaveworth or Yaneworth Thomas husbandman 587789 587789 Yaveworth or Yaneworth, Thomas, of Longford by Gloucester, husbandman 0
4811847 2299818 2299818 defendant Ingleys (illegible) husbandman 587789 587789 Ingleys, ----, of Longford, husbandman 1
4811848 2299818 2299818 defendant Dolle Walter husbandman 587789 587789 Dolle, Walter, of Longford, husbandman 2
4811849 2299818 2299818 defendant Capenore John husbandman 587789 587789 Capenore, John, of Longford, husbandman 3
4848417 2310979 2310979 defendant Hally Hugh yeoman 587789 587789 Hally, Hugh, of Longford, yeoman 0
4876069 2319475 2319475 defendant Halley Hugh yeoman 587789 587789 Halley, Hugh, of Longford, yeoman 1
4966417 2346887 2346887 defendant del Stokes Henry yeoman 587789 587789 del Stokes, Henry, of Longford, yeoman 0
5011713 2360274 2360274 defendant Halle Hugh husbandman 587789 587789 Halle, Hugh, of Longford, husbandman 0
5021767 2363260 2363260 defendant Chorleton Geoffrey yeoman 587789 587789 Chorleton, Geoffrey, of Longford, yeoman 1
5040435 2368743 2368743 defendant Wotton William husbandman 587789 587789 Wotton, William, of Longford, husbandman 1
5053711 2372709 2372709 defendant Capenore John, junior husbandman 587789 587789 Capenore, John, junior, of Longford, husbandman 2
5053712 2372709 2372709 defendant Rostell Nicholas laborer 587789 587789 Rostell, Nicholas, of Longford, laborer 3
5057359 2373768 2373768 defendant Ratclyfe Geoffrey yeoman 587789 587789 Ratclyfe, Geoffrey, of Longford, yeoman 0
5074682 2378934 2378934 defendant Mable Edmund husbandman 587789 587789 Mable, Edmund, of Longford, husbandman 0
5074685 2378934 2378934 defendant Waleys Thomas husbandman 587789 587789 Waleys, Thomas,of Longford, husbandman 3
5074686 2378934 2378934 defendant Mable John husbandman 587789 587789 Mable, John, of Longford, husbandman 4
5074688 2378935 2378935 defendant Mable Edmund husbandman 587789 587789 Mable, Edmund, of Longford, husbandman 0
5074691 2378935 2378935 defendant Waleys Thomas husbandman 587789 587789 Waleys, Thomas, of Longford, husbandman 3
5074692 2378935 2378935 defendant Mabler John husbandman 587789 587789 Mabler, John, of Longford, husbandman 4
5091921 2384017 2384017 defendant Halley Hugh yeoman 587789 587789 Halley, Hugh, of Longford, yeoman 2
5176000 2408664 2408664 defendant Spakeman William husbandman 587789 587789 Spakeman, William, of Longford, husbandman 5
5183268 2410849 2410849 defendant Robynson Nicholas yeoman 587789 587789 Robynson, Nicholas, of Longford, yeoman 2
5183269 2410849 2410849 defendant Stokkes Henry yeoman 587789 587789 Stokkes, Henry, of Longford, yeoman 3
5183273 2410850 2410850 defendant Robynson Nicholas yeoman 587789 587789 Robynson, Nicholas, of Longford, yeoman 2
5183274 2410850 2410850 defendant Stokkes Henry yeoman 587789 587789 Stokkes, Henry, of Longford, yeoman 3
5183278 2410851 2410851 defendant Robynson Nicholas yeoman 587789 587789 Robynson, Nicholas, of Longford, yeoman 2
5183279 2410851 2410851 defendant Stokkes Henry yeoman 587789 587789 Stokkes, Henry, of Longford, yeoman 3
5183283 2410852 2410852 defendant Robynson Nicholas yeoman 587789 587789 Robynson, Nicholas, of Longford, yeoman 2
5183284 2410852 2410852 defendant Stokkes Henry yeoman 587789 587789 Stokkes, Henry, of Longford, yeoman 3
5203806 2416864 2416864 defendant Stokkes Henry yeoman 587789 587789 Stokkes, Henry, of Longford, yeoman 3
5203811 2416865 2416865 defendant Stokkes Henry yeoman 587789 587789 Stokkes, Henry, of Longford, yeoman 3
5262044 2433878 2433878 defendant Bedell John husbandman 587789 587789 Bedell, John, of Longford, husbandman 2
5282491 2439940 2439940 defendant Tatton Oliver yeoman 587789 587789 Tatton, Oliver, of Longford, yeoman 2
5282492 2439940 2439940 defendant Robynson Nicholas yeoman 587789 587789 Robynson, Nicholas, of Longford, yeoman 3
5282493 2439940 2439940 defendant Halley Thomas yeoman 587789 587789 Halley, Thomas, of Longford, yeoman 4
5282494 2439940 2439940 defendant Hathersege Ralph yeoman 587789 587789 Hathersege, Ralph, of Longford, yeoman 5
5282495 2439940 2439940 defendant Milner Robert miller 587789 587789 Milner, Robert, of Longford, miller 6
5282496 2439940 2439940 defendant Baker John husbandman 587789 587789 Baker, John, of Longford, husbandman 7
5301620 2445439 2445439 defendant Tatton Oliver yeoman 587789 587789 Tatton, Oliver, of Longford, yeoman 2
5301621 2445439 2445439 defendant Robynson Nicholas yeoman 587789 587789 Robynson, Nicholas, of Longford, yeoman 3
5301622 2445439 2445439 defendant Halley Thomas yeoman 587789 587789 Halley, Thomas, of Longford, yeoman 4
5301623 2445439 2445439 defendant Hathersege Ralph yeoman 587789 587789 Hathersege, Ralph, of Longford, yeoman 5
5301624 2445439 2445439 defendant Miller Robert miller 587789 587789 Miller, Robert, of Longford, miller 6
5301625 2445439 2445439 defendant Baler John husbandman 587789 587789 Baler, John, of Longford, husbandman 7
5301630 2445440 2445440 defendant Robynson Nicholas yeoman 587789 587789 Robynson, Nicholas, of Longford, yeoman 3
5301631 2445440 2445440 defendant Halley Thomas yeoman 587789 587789 Halley, Thomas, of Longford, yeoman 4
5301632 2445440 2445440 defendant Hathersege Ralph yeoman 587789 587789 Hathersege, Ralph, of Longford, yeoman 5
5301633 2445440 2445440 defendant Milner Robert milner 587789 587789 Milner, Robert, of Longford, milner 6
5301634 2445440 2445440 defendant Baker John husbandman 587789 587789 Baker, John, of Longford, husbandman 7
5302696 2445785 2445785 defendant Roberd John miller 587789 587789 Roberd, John, of Longford, miller 0
5302697 2445785 2445785 defendant Tanner John yeoman 587789 587789 Tanner, John, of Longford, yeoman 1
5316397 2449984 2449984 defendant Tatton Olicer yeoman 587789 587789 Tatton, Olicer, of Longford,yeoman 2
5316398 2449984 2449984 defendant Robynson Nicholas yeoman 587789 587789 Robynson, Nicholas, of Longford, 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);