names

66 rows where place_id = 591239

✎ 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
3603827 1868869 1868869 defendant Everton Robert brewer 591239 591239 Everton, Robert, of Hakeney, Middx, brewer 1
3604754 1869151 1869151 defendant Tommyll Ralph yeoman 591239 591239 Tommyll, Ralph, of Hakeney, Middx, yeoman 1
3605549 1869402 1869402 defendant Body Richard husbandman 591239 591239 Body, Richard, of Hakeney, Middx, husbandman 0
3616226 1872716 1872716 defendant Body Richard brewer 591239 591239 Body, Richard, of Hakeney, Middx, brewer 1
3638281 1906791 1906791 defendant Saunders alias Clerk Thomas   591239 591239 Saunders alias Clerk, Thomas, of Hakeney, Middx, "coygnour" 4
3722064 1933164 1933164 defendant Maxfeld Robert yeoman 591239 591239 Maxfeld, Robert, of Hakeney, Middx, yeoman 1
3735174 1937235 1937235 defendant Russell John gent 591239 591239 Russell, John, of Hakeney, Middx, gent 0
3793641 1955873 1955873 defendant Sadler Henry gent 591239 591239 Sadler, Henry, of Hakeney, Middx, gent 0
3801707 1958428 1958428 defendant Knevett William gent 591239 591239 Knevett, William, of Hakeney, Middx, gent 0
3827750 1966546 1966546 defendant Heron Edmund gent 591239 591239 Heron, Edmund, of Hakeney, Middx, gent 0
3850675 1973800 1973800 defendant Knyvett William esq 591239 591239 Knyvett, William, of Hakeney, Middx, esq 0
3850677 1973801 1973801 defendant Knyvett William esq 591239 591239 Knyvett, William, of Hakeney, Middx, esq 0
3850679 1973802 1973802 defendant Knyvett William esq 591239 591239 Knyvett, William, of Hakeney, Middx, esq 0
3931744 2000920 2000920 defendant Bowes John (legal representative) 591239 591239 Bowes, John, of Hakeney, Middx, gent, executors of 1
3937104 2002745 2002745 defendant Elryngton John gent 591239 591239 Elryngton, John, of Hakeney, Middx, gent 0
4849248 2311241 2311241 defendant Fissher Richard fishmonger 591239 591239 Fissher, Richard, of Hakeney, Middx, fishmonger 0
4861861 2315087 2315087 defendant Hakeney John husbandman 591239 591239 Hakeney, John, of Hakeney, Middx, husbandman 2
4876899 2319744 2319744 defendant Fyssher Richard fisher 591239 591239 Fyssher, Richard, of Hakeney, Middx, fisher 0
4884407 2322024 2322024 plaintiff Auston William   591239 591239 Auston, William, of Hakeney, Middx 0
4893917 2324798 2324798 defendant Mason Roger yeoman 591239 591239 Mason, Roger, of Hakeney, Middx, yeoman 0
4901665 2327123 2327123 plaintiff Auston William   591239 591239 Auston, William, of Hakeney, Middx 0
4901974 2327220 2327220 defendant Drieman John husbandman 591239 591239 Drieman, John, of Hakeney, Middx, husbandman 1
4910929 2329930 2329930 defendant Dowenmer John yeoman 591239 591239 Dowenmer, John, of Hakeney, Middx, yeoman 0
4916081 2331530 2331530 defendant Alverd William husbandman 591239 591239 Alverd, William, of Hakeney, Middx, husbandman 2
4966427 2346891 2346891 defendant Tillesley Elias gent 591239 591239 Tillesley, Elias, of Hakeney, Middx, gent 0
5015459 2361404 2361404 plaintiff Botyrfeld John draper 591239 591239 Botyrfeld, John, of Hakeney, Middx, draper 0
5015464 2361405 2361405 plaintiff Botyrfeld John draper 591239 591239 Botyrfeld, John, of Hakeney, Middx, draper 0
5037699 2367898 2367898 defendant Baker Thomas husbandman 591239 591239 Baker, Thomas, of Hakeney, Middx, husbandman 1
5092331 2384135 2384135 defendant Heritage Henry hackneyman 591239 591239 Heritage, Henry, of Hakeney, Middx, hackneyman 1
5092763 2384262 2384262 defendant Everard Alice widow 591239 591239 Everard, Alice, of Hakeney, Middx, widow 3
5095691 2385161 2385161 defendant Botyrfeld John yeoman 591239 591239 (Botyrfeld, John, of Hakeney, Middx, yeoman 5
5103397 2387421 2387421 defendant Bende henry yeoman 591239 591239 Bende, henry, of Hakeney, Middx, yeoman 2
5119762 2392218 2392218 defendant Watson William hackneyman 591239 591239 Watson, William, of Hakeney, Middx, hackneyman 1
5119768 2392219 2392219 defendant Watson William hackneyman 591239 591239 Watson, William, of Hakeney, Middx, hackneyman 1
5127528 2394529 2394529 defendant Barton Robert esq 591239 591239 Barton, Robert, of Hakeney, Middx, esq 0
5146403 2400079 2400079 defendant Barton Robert esq 591239 591239 Barton, Robert, of Hakeney, Middx, esq 0
5156956 2403175 2403175 defendant Honybourne John husbandman 591239 591239 Honybourne, John, of Hakeney, Middx, husbandman 0
5214492 2419968 2419968 defendant Austyn Thomas yeoman 591239 591239 Austyn, Thomas, of Hakeney, Middx, yeoman 4
5221035 2421853 2421853 defendant Tunley Thomas   591239 591239 Tunley, Thomas, of Hakeney, Middx, cerk 0
5221781 2422067 2422067 defendant Erle Walter yeoman 591239 591239 Erle, Walter, of Hakeney, Middx, yeoman 0
5225461 2423122 2423122 defendant Barton Robert esq 591239 591239 Barton, Robert, of Hakeney, Middx, esq 1
5233178 2425291 2425291 defendant Shordyche Robert esq 591239 591239 Shordyche, Robert, of Hakeney, Middx, esq 1
5247109 2429312 2429312 defendant Bokeland John yeoman 591239 591239 Bokeland, John, of Hakeney, Middx, yeoman 1
5270380 2436438 2436438 defendant Dynand Thomas   591239 591239 Dynand, Thomas, of Hakeney, Middx, hakney man 0
5351875 2460689 2460689 defendant Brokke Alexander yeoman 591239 591239 Brokke, Alexander, of Hakeney, Middx, yeoman 0
5360938 2463446 2463446 defendant A More John smith 591239 591239 A More, John, of Hakeney, Middx, smith 0
5363353 2464192 2464192 defendant Serle Walter yeoman 591239 591239 Serle, Walter, of Hakeney, Middx, yeoman 0
5366275 2465109 2465109 plaintiff Brok Alexander yeoman 591239 591239 Brok, Alexander, of Hakeney, Middx, yeoman 0
5387204 2471411 2471411 plaintiff Elryngton John gent 591239 591239 Elryngton, John, of Hakeney, Middx, gent, on his own account 0
5399635 2474979 2474979 plaintiff Elryngton John gent 591239 591239 Elryngton, John, of Hakeney, Middx, gent 0
5399637 2474980 2474980 plaintiff Elryngton John gent 591239 591239 Elryngton, John, of Hakeney, Middx, gent 0
5418782 2480541 2480541 defendant Brokke Alexander yeoman 591239 591239 Brokke, Alexander, of Hakeney, Middx, yeoman 0
5418785 2480542 2480542 defendant Brok Alexander gent 591239 591239 Brok, Alexander, of Hakeney, Middx, gent 0
5418788 2480543 2480543 defendant Brok Alexander gent 591239 591239 Brok, Alexander, of Hakeney, Middx, gent 0
5420212 2480964 2480964 defendant Mounten John laborer 591239 591239 Mounten, John, of Hakeney, Middx, laborer 0
5433106 2484867 2484867 defendant Clayton John tanner 591239 591239 Clayton, John, of Hakeney, Middx, tanner 4
5463811 2494092 2494092 defendant Colyns John husbandman 591239 591239 Colyns, John, of Hakeney, Middx, husbandman 0
5463828 2494096 2494096 defendant Colyns John husbandman 591239 591239 Colyns, John, of Hakeney, Middx, husbandman 3
5519736 2511006 2511006 defendant Doweshed John clerk 591239 591239 Doweshed, John, of Hakeney, Middx, clerk 0
5542915 2517903 2517903 defendant Elryngton John gent 591239 591239 (Elryngton, John, of Hakeney, Middx, gent 1
5564916 2524326 2524326 defendant Naylard John husbandman 591239 591239 Naylard, John, of Hakeney, Middx, husbandman 0
5576316 2527649 2527649 defendant Hyll Stephen gent 591239 591239 Hyll, Stephen, of Hakeney, Middx, gent 0
5581825 2529394 2529394 defendant Skylle John gent 591239 591239 Skylle, John, of Hakeney, Middx, gent 1
5582665 2529646 2529646 defendant Toppysfeld William (legal representative) 591239 591239 Toppysfeld, William, of Hakeney, Middx, husbandman, executrix of 2
5582668 2529647 2529647 defendant Toppesfeld William (legal representative) 591239 591239 Toppesfeld, William, of Hakeney, Middx, husbandman, executrix of 0
5590702 2532066 2532066 defendant Grene John yeoman 591239 591239 Grene, John, of Hakeney, Middx, yeoman 0

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