names

78 rows where place_id = 597364

✎ 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
3628278 1903705 1903705 defendant Bageley James yeoman 597364 597364 Bageley, James, of Cosyngton, yeoman 3
3628279 1903705 1903705 defendant Akyrley John husbandman 597364 597364 Akyrley, John, of Cosyngton, husbandman 4
3782292 1952217 1952217 defendant Brent William esq 597364 597364 Brent, William, of Cosyngton, esq 0
3782293 1952217 1952217 defendant Kewe Thomas chaplain 597364 597364 Kewe, Thomas, of Cosyngton, chaplain 1
3782294 1952217 1952217 defendant Fry John yeoman 597364 597364 Fry, John, of Cosyngton, yeoman 2
3782295 1952217 1952217 defendant Morgan John yeoman 597364 597364 Morgan, John, of Cosyngton, yeoman 3
3782296 1952217 1952217 defendant Cutter John yeoman 597364 597364 Cutter, John, of Cosyngton, yeoman 4
3782297 1952217 1952217 defendant Gover John yeroman 597364 597364 Gover, John, of Cosyngton, yeroman 5
3787265 1953812 1953812 defendant Brent William esq 597364 597364 Brent, William, of Cosyngton, esq 0
3787266 1953812 1953812 defendant Fry John yeoman 597364 597364 Fry, John, of Cosyngton, yeoman 1
3787267 1953812 1953812 defendant Morgan John yeoman 597364 597364 Morgan, John, of Cosyngton, yeoman 2
3787268 1953812 1953812 defendant Cutter John yeoman 597364 597364 Cutter, John, of Cosyngton, yeoman 3
3787269 1953812 1953812 defendant Gover John yeoman 597364 597364 Gover, John, of Cosyngton, yeoman 4
3791572 1955205 1955205 defendant Brent William esq 597364 597364 Brent, William, of Cosyngton, esq 0
3791573 1955205 1955205 defendant Fry John yeoman 597364 597364 Fry, John, of Cosyngton, yeoman 1
3791574 1955205 1955205 defendant Morgan John yeoman 597364 597364 Morgan, John, of Cosyngton, yeoman 2
3791575 1955205 1955205 defendant Cutter John yeoman 597364 597364 Cutter, John, of Cosyngton, yeoman 3
3791576 1955205 1955205 defendant Cover John yeroman 597364 597364 Cover, John, of Cosyngton, yeroman 4
3910863 1993956 1993956 defendant Muston Thomas husbandman 597364 597364 Muston, Thomas, of Cosyngton, husbandman 0
4026923 2034278 2034278 defendant Babyngton Humphrey gent 597364 597364 Babyngton, Humphrey, of Cosyngton, gent 0
4131205 2071481 2071481 defendant Boultinge James yeoman 597364 597364 Boultinge, James, of Cosyngton, yeoman 0
4447743 2184220 2184220 defendant Sounerny Roger   597364 597364 Sounerny, Roger, of Cosyngton 0
4460964 2188500 2188500 plaintiff Somervyll Roger   597364 597364 Somervyll, Roger, of Cosyngton 0
4460966 2188501 2188501 plaintiff Somervyll Roger   597364 597364 Somervyll, Roger, of Cosyngton 0
4473253 2192297 2192297 plaintiff Crispe Willia   597364 597364 Crispe, Willia, of Cosyngton 0
4473257 2192298 2192298 plaintiff Crispe William   597364 597364 Crispe, William, of Cosyngton, on his own account 0
4630384 2240412 2240412 plaintiff Stokes John   597364 597364 Stokes, John, of Cosyngton 0
4645461 2244741 2244741 defendant Glover Robert   597364 597364 Glover, Robert, of Cosyngton 0
4646931 2245167 2245167 defendant Preston William   597364 597364 Preston, William, of Cosyngton 1
4646939 2245167 2245167 defendant Mortymore William   597364 597364 Mortymore, William, of Cosyngton 9
4663822 2250169 2250169 defendant Asselyn Geoffrey husbandman 597364 597364 Asselyn, Geoffrey, of Cosyngton, husbandman 1
4692908 2263291 2263291 plaintiff Bailly John   597364 597364 Bailly, John, of Cosyngton 0
4736458 2276534 2276534 defendant Bate Robert clerk 597364 597364 Bate, Robert, of Cosyngton, clerk 0
4740344 2277686 2277686 defendant Pynkeny Thomas husbandman 597364 597364 Pynkeny, Thomas, of Cosyngton, husbandman 0
4740345 2277686 2277686 defendant Somurvile William husbandman 597364 597364 Somurvile, William, of Cosyngton, husbandman 1
4740346 2277686 2277686 defendant Persones John husbandman 597364 597364 Persones, John, of Cosyngton, husbandman 2
4750313 2280569 2280569 plaintiff Pynkeny Thomas   597364 597364 Pynkeny, Thomas, of Cosyngton 0
4750314 2280569 2280569 defendant Hulcok Robert husbandman 597364 597364 Hulcok, Robert, of Cosyngton, husbandman 0
4750315 2280569 2280569 defendant Hulcok Reginald husbandman 597364 597364 Hulcok, Reginald, of Cosyngton, husbandman 1
4755604 2282135 2282135 defendant Somurvyle William husbandman 597364 597364 Somurvyle, William, of Cosyngton, husbandman 0
4771407 2287039 2287039 defendant Brunyng Thomas clerk 597364 597364 Brunyng, Thomas, of Cosyngton, formerly of Writlyngton, clerk 0
4777519 2288963 2288963 defendant Somurvyle William husbandman 597364 597364 Somurvyle, William, of Cosyngton, husbandman 0
4777521 2288964 2288964 defendant Pynkeney Thomas husbandman 597364 597364 Pynkeney, Thomas, of Cosyngton, husbandman 0
4787643 2292205 2292205 defendant Hulcokke Robert husbandman 597364 597364 Hulcokke, Robert, of Cosyngton, husbandman 1
4796385 2295019 2295019 defendant Brunyng Thomas clerk 597364 597364 Brunyng, Thomas, of Cosyngton, or of Wrytlyngton, clerk 0
4830425 2305550 2305550 defendant German John husbandman 597364 597364 German, John, of Cosyngton, husbandman 3
4833106 2306373 2306373 defendant Tredoke John gent 597364 597364 Tredoke, John, of Cosyngton, gent 3
4833130 2306376 2306376 defendant Tredeke John husbandman 597364 597364 Tredeke, John, of Cosyngton, husbandman 2
4839616 2308307 2308307 defendant German John   597364 597364 German, John, of Cosyngton, franklin 0
4872455 2318346 2318346 defendant Somervyle William husbandman 597364 597364 together with Somervyle, William, of Cosyngton, husbandman 1
4872456 2318346 2318346 defendant Godefelowe Roger husbandman 597364 597364 Godefelowe, Roger, of Cosyngton, husbandman 2
4922290 2333389 2333389 defendant German Stephen husbandman 597364 597364 German, Stephen, of Cosyngton, husbandman 2
4922291 2333389 2333389 defendant Bateman Helen widow 597364 597364 Bateman, Helen, of Cosyngton, widow 3
4939847 2338851 2338851 defendant Somervyle William   597364 597364 Somervyle, William, of Cosyngton, franklin 1
4960443 2345088 2345088 defendant Bramburgh Christopher gent 597364 597364 Bramburgh, Christopher, of Cosyngton, gent 0
4960444 2345088 2345088 defendant Somervyle William gent 597364 597364 Somervyle, William, of Cosyngton, gent 1
4984984 2352443 2352443 defendant Hulcok Reginald husbandman 597364 597364 Hulcok, Reginald, of Cosyngton, husbandman 0
4985000 2352445 2352445 defendant Hulcok Reginald husbandman 597364 597364 Hulcok, Reginald, of Cosyngton, husbandman 0
5012122 2360395 2360395 defendant Clerk Robert husbandman 597364 597364 Clerk, Robert, of Cosyngton, husbandman 3
5012123 2360395 2360395 defendant Clerk William chaplain 597364 597364 Clerk, William, of Cosyngton, chaplain 4
5065657 2376257 2376257 defendant Hortop Richard husbandman 597364 597364 Hortop, Richard, of Cosyngton, husbandman 0
5154328 2402423 2402423 defendant Medburn John husbandman 597364 597364 Medburn, John, of Cosyngton, husbandman 0
5154329 2402423 2402423 defendant Bayly Thomas   597364 597364 Bayly, Thomas, of Cosyngton, servant 1
5154330 2402423 2402423 defendant Hulkok Reginald husbandman 597364 597364 Hulkok, Reginald, of Cosyngton, husbandman 2
5162664 2404800 2404800 defendant Hulkot Reginald husbandman 597364 597364 Hulkot, Reginald, of Cosyngton, husbandman 0
5162665 2404800 2404800 defendant Hulkot Robert husbandman 597364 597364 Hulkot, Robert, of Cosyngton, husbandman 1
5162666 2404800 2404800 defendant Somervyle William gent 597364 597364 Somervyle, William, of Cosyngton, gent 2
5171443 2407372 2407372 defendant Medburn John husbandman 597364 597364 Medburn, John, of Cosyngton, husbandman 0
5171444 2407372 2407372 defendant Bayly Thomas   597364 597364 Bayly, Thomas, of Cosyngton, servant 1
5171445 2407372 2407372 defendant Hulkok Reginald husbandman 597364 597364 Hulkok, Reginald, of Cosyngton, husbandman 2
5186269 2411736 2411736 defendant Horetoppe Richard husbandman 597364 597364 Horetoppe, Richard, of Cosyngton, husbandman 0
5237949 2426687 2426687 defendant Blithe Alexander yeoman 597364 597364 Blithe, Alexander, of Cosyngton, yeoman 2
5279041 2438979 2438979 defendant Kene Robert smith 597364 597364 Kene, Robert, of Cosyngton, smith 0
5294112 2443251 2443251 defendant Moreys Thomas husbandman 597364 597364 Moreys, Thomas, of Cosyngton, husbandman 0
5459440 2492737 2492737 defendant Morys Thomas clerk 597364 597364 Morys, Thomas, of Cosyngton, clerk 1
5471166 2496312 2496312 defendant Morys Thomas clerk 597364 597364 Morys, Thomas, of Cosyngton, clerk 0
5590380 2531962 2531962 defendant Huls John yeoman 597364 597364 Huls, John, of Cosyngton, yeoman 0
5629150 2553088 2553088 defendant Hande Robert husbandman 597364 597364 Hande, Robert, of Cosyngton, husbandman 5

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