names

112 rows where place_id = 592525

✎ 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
3607967 1870142 1870142 defendant Neweton Thomas husbandman 592525 592525 Neweton, Thomas, of Wolverton, husbandman 0
3637688 1906601 1906601 defendant Walford Thomas yeoman 592525 592525 Walford, Thomas, of Wolverton, yeoman 2
3638538 1906869 1906869 defendant Raglond Margaret widow 592525 592525 Raglond, Margaret, of Wolverton, widow 0
3652887 1911229 1911229 defendant Gate William husbandman 592525 592525 Gate, William, of Wolverton, husbandman 0
3657042 1912464 1912464 defendant Jogyns John husbandman 592525 592525 Jogyns, John, of Wolverton, husbandman 3
3687116 1922143 1922143 defendant Franklyn Robert yeoman 592525 592525 Franklyn, Robert, of Wolverton, yeoman 1
3778289 1950920 1950920 defendant Vygor John husbandman 592525 592525 Vygor, John, of Wolverton, husbandman 0
3826955 1966281 1966281 defendant Browne William husbandman 592525 592525 Browne, William, of Wolverton, husbandman 0
3841817 1971023 1971023 defendant Brome John husbandman 592525 592525 Brome, John, of Wolverton, husbandman 1
3852082 1974244 1974244 defendant Browne John husbandman 592525 592525 Browne, John, of Wolverton, husbandman 0
3891738 1987491 1987491 plaintiff Longvile John (legal representative) 592525 592525 Longvile, John, of Wolverton, administrator of 0
3892162 1987634 1987634 defendant Johnson Thomas yeoman 592525 592525 Johnson, Thomas, of Wolverton, yeoman 0
3912824 1994621 1994621 defendant Hyckes John clerk 592525 592525 Hyckes, John, of Wolverton, clerk 2
3933069 2001354 2001354 defendant Sheperde William laborer 592525 592525 Sheperde, William, of Wolverton, laborer 1
3963282 2011760 2011760 defendant Sturges John gent 592525 592525 Sturges, John, of Wolverton, or of Bekeynton, Soms, gent 0
4096397 2059042 2059042 defendant Twynneho George gent 592525 592525 Twynneho, George, of Wolverton, gent 0
4102226 2061088 2061088 defendant Sturges John gent 592525 592525 Sturges, John, of Wolverton, gent 0
4118496 2066907 2066907 defendant Nowell Christopher husbandman 592525 592525 Nowell, Christopher, of Wolverton, husbandman 1
4171732 2085579 2085579 defendant Hargraves John fisherman 592525 592525 Hargraves, John, of Wolverton, fisherman 0
4171737 2085580 2085580 defendant Smythe John fisherman 592525 592525 Smythe, John, of Wolverton, fisherman 3
4171739 2085580 2085580 defendant Gates William   592525 592525 Gates, William, of Wolverton, cook 5
4171740 2085580 2085580 defendant Tompson Thomas fisherman 592525 592525 Tompson, Thomas, of Wolverton, fisherman 6
4171742 2085580 2085580 defendant Grenelef Thomas, junior laborer 592525 592525 Grenelef, Thomas, junior, of Wolverton, laborer 8
4171747 2085581 2085581 defendant Smythe John fisherman 592525 592525 Smythe, John, of Wolverton, fisherman 3
4171749 2085581 2085581 defendant Gates William   592525 592525 Gates, William, of Wolverton, cook 5
4171750 2085581 2085581 defendant Tompson Thomas fisherman 592525 592525 Tompson, Thomas, of Wolverton, fisherman 6
4171752 2085581 2085581 defendant Grenelef Thomas, junior laborer 592525 592525 Grenelef, Thomas, junior, of Wolverton, laborer 8
4171757 2085582 2085582 defendant Blackewell Robert husbandman 592525 592525 Blackewell, Robert, of Wolverton, husbandman 3
4171758 2085582 2085582 defendant Duplacke Thomas carpenter 592525 592525 Duplacke, Thomas, of Wolverton, carpenter 4
4171759 2085582 2085582 defendant Smythe Margaret spinster 592525 592525 Smythe, Margaret, of Wolverton, spinster 5
4171762 2085583 2085583 defendant Hockham John   592525 592525 Hockham, John, of Wolverton, shepherd 1
4171763 2085583 2085583 defendant Gates William   592525 592525 Gates, William, of Wolverton, cook 2
4171764 2085583 2085583 defendant Freeston Robert husbandman 592525 592525 Freeston, Robert, of Wolverton, husbandman 3
4194864 2093766 2093766 defendant Hargraves John fisherman 592525 592525 Hargraves, John, of Wolverton, fisherman 0
4274754 2121115 2121115 defendant Sadler John gent 592525 592525 Sadler, John, of Wolverton, gent 0
4285315 2124798 2124798 defendant Morse William husbandman 592525 592525 Morse, William, of Wolverton, husbandman 0
4285316 2124798 2124798 defendant Grounde Emund or Edmund husbandman 592525 592525 Grounde, Emund or Edmund, of Wolverton, husbandman 1
4285317 2124798 2124798 defendant Mills Thomas husbandman 592525 592525 Mills, Thomas, of Wolverton, husbandman 2
4285318 2124798 2124798 defendant Mayer John husbandman 592525 592525 Mayer, John, of Wolverton, husbandman 3
4308096 2132976 2132976 defendant Knight John husbandman 592525 592525 Knight, John, of Wolverton, husbandman 0
4308097 2132976 2132976 defendant Sherman Thomas husbandman 592525 592525 Sherman, Thomas, of Wolverton, husbandman 1
4326695 2139284 2139284 defendant Sadler John gent 592525 592525 Sadler, John, of Wolverton, gent 1
4370019 2154334 2154334 defendant Vessey Richard mariner 592525 592525 Vessey, Richard, of Wolverton, mariner 0
4370020 2154334 2154334 defendant Buckenham John mariner 592525 592525 Buckenham, John, of Wolverton, mariner 1
4378681 2157447 2157447 plaintiff Sturgis John   592525 592525 Sturgis, John, of Wolverton, Soms gent 0
4397744 2163823 2163823 defendant Vessey Richard mariner 592525 592525 Vessey, Richard, of Wolverton, mariner 0
4397745 2163823 2163823 defendant Buckenham John mariner 592525 592525 Buckenham, John, of Wolverton, mariner 1
4399483 2164413 2164413 defendant Deane Christopher gent 592525 592525 Deane, Christopher, of Wolverton, gent 1
4473997 2192518 2192518 defendant Hewes John   592525 592525 Hewes, John, of Wolverton 0
4486462 2196475 2196475 defendant Oxherde Nicholas   592525 592525 Oxherde, Nicholas, of Wolverton 5
4497024 2199732 2199732 defendant Hewes John   592525 592525 Hewes, John, of Wolverton 0
4502627 2201403 2201403 defendant Vessy John   592525 592525 Vessy, John, of Wolverton 0
4514297 2204888 2204888 defendant Sankyn Thomas   592525 592525 Sankyn, Thomas, of Wolverton 1
4514298 2204888 2204888 defendant Mulward Roger   592525 592525 Mulward, Roger, of Wolverton 2
4527606 2208913 2208913 plaintiff Longevyle John   592525 592525 Longevyle, John, of wolverton 0
4527609 2208914 2208914 plaintiff Longevyle John   592525 592525 Longevyle, John, of wolverton 0
4527615 2208917 2208917 plaintiff Longevyll John   592525 592525 Longevyll, John, of Wolverton 0
4533212 2210647 2210647 plaintiff Renoe William   592525 592525 Renoe, William, of Wolverton 0
4554785 2217424 2217424 defendant Aubyn Walter   592525 592525 Aubyn, Walter, of Wolverton 2
4556011 2217822 2217822 defendant Palmere William   592525 592525 Palmere, William, of Wolverton 0
4556012 2217822 2217822 defendant Muuleward William   592525 592525 Muuleward, William, of Wolverton 1
4644140 2244382 2244382 defendant Hastyng John   592525 592525 Hastyng, John, of Wolverton 0
4644144 2244383 2244383 plaintiff Longevyll John   592525 592525 Longevyll, John, of Wolverton 0
4676252 2258184 2258184 defendant Larwode John husbandman 592525 592525 Larwode, John, of Wolverton, husbandman 1
4678441 2258864 2258864 defendant Gylleson Thomas husbandman 592525 592525 Gylleson, Thomas, of Wolverton, husbandman 1
4686130 2261256 2261256 defendant Longvile John esq 592525 592525 Longvile, John, of Wolverton, esq 0
4708573 2268052 2268052 defendant Smyth William husbandman 592525 592525 Smyth, William, of Wolverton, husbandman 0
4717144 2270690 2270690 defendant Aubyn Walter husbandman 592525 592525 Aubyn, Walter, of Wolverton, husbandman 0
4717204 2270711 2270711 defendant Dene John husbandman 592525 592525 Dene, John, of Wolverton, husbandman 0
4718078 2270995 2270995 defendant Jurdan John   592525 592525 Jurdan, John, of Wolverton 2
4733423 2275630 2275630 defendant Longevyll George esq 592525 592525 Longevyll, George, of Wolverton, esq 0
4764058 2284746 2284746 defendant Fynoll William butcher 592525 592525 Fynoll, William, of Wolverton, butcher 1
4770404 2286713 2286713 defendant Longevyle George esq 592525 592525 Longevyle, George, of Wolverton, esq 0
4791104 2293317 2293317 plaintiff Longevill George   592525 592525 Longevill, George, of Wolverton 0
4795134 2294624 2294624 defendant Longevyll George esq 592525 592525 Longevyll, George, of Wolverton, esq 0
4846787 2310502 2310502 defendant Longvyll George esq 592525 592525 Longvyll, George, of Wolverton, esq 0
4856441 2313392 2313392 defendant Turneham Thomas husbandman 592525 592525 Turneham, Thomas, of Wolverton, husbandman 0
4870086 2317611 2317611 defendant Parchemyner William miller 592525 592525 Parchemyner, William, of Wolverton, miller 0
4870087 2317611 2317611 defendant Parchemyner John laborer 592525 592525 Parchemyner, John, of Wolverton, laborer 1
4870090 2317612 2317612 defendant Hastyng Richard tailor 592525 592525 Hastyng, Richard, of Wolverton, tailor 1
4879129 2320406 2320406 defendant Burnham Thomas husbandman 592525 592525 Burnham, Thomas, of Wolverton, husbandman 0
4886171 2322535 2322535 defendant Davy John yeoman 592525 592525 Davy, John, of Wolverton, yeoman 0
4949682 2341896 2341896 plaintiff Nores Nicholas   592525 592525 Nores, Nicholas, of Wolverton 0
4953762 2343084 2343084 defendant Tonneson alias Geffull John husbandman 592525 592525 Tonneson alias Geffull, John, of Wolverton, husbandman 0
4966882 2347020 2347020 defendant Taylour David tailor 592525 592525 Taylour, David, of Wolverton, tailor 1
4977999 2350385 2350385 defendant Hastyng John husbandman 592525 592525 Hastyng, John, of Wolverton, husbandman 2
4979894 2350943 2350943 defendant Hastyng Richard tailor 592525 592525 Hastyng, Richard, of Wolverton, tailor 0
4984842 2352395 2352395 defendant Baldewyn Richard husbandman 592525 592525 Baldewyn, Richard, of Wolverton, husbandman 3
4996536 2355817 2355817 defendant Brere John chapman 592525 592525 Brere, John, of Wolverton, chapman 0
5031862 2366191 2366191 defendant Hastyng John yeoman 592525 592525 Hastyng, John, of Wolverton, yeoman 2
5036261 2367457 2367457 defendant Bartelet John husbandman 592525 592525 Bartelet, John, of Wolverton, husbandman 4
5089702 2383362 2383362 defendant Dyneley or Dyveley Robert, senior gent 592525 592525 Dyneley or Dyveley, Robert, senior, of Wolverton, gent 0
5089704 2383362 2383362 defendant Dyneley or Dyveley John gent 592525 592525 Dyneley or Dyveley, John, of Wolverton, gent 2
5089707 2383363 2383363 defendant Dyneley Robert, senior gent 592525 592525 Dyneley, Robert, senior, of Wolverton, gent 0
5104418 2387718 2387718 defendant Cheyne William husbandman 592525 592525 Cheyne, William, of Wolverton, husbandman 1
5107897 2388746 2388746 defendant Bussok John husbandman 592525 592525 Bussok, John, of Wolverton, husbandman 1
5119542 2392146 2392146 defendant Smyth Gilbert yeoman 592525 592525 Smyth, Gilbert, of Wolverton, yeoman 1
5119547 2392147 2392147 defendant Smyth Gilbert yeoman 592525 592525 Smyth, Gilbert, of Wolverton, yeoman 2
5120024 2392293 2392293 defendant Jambywey John weaver 592525 592525 Jambywey, John, of Wolverton, weaver 0
5201028 2416056 2416056 defendant Wright Robert husbandman 592525 592525 Wright, Robert, of Wolverton, husbandman 0

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