APIs

Law Firm Profile

Manish bhargava — Tue, 08 May 2012 13:59:38 GMT

Current revision posted to APIs by Manish bhargava on 5/8/2012 9:59:38 AM

Coming in June...

Lawyer Profile

Manish bhargava — Tue, 08 May 2012 13:59:10 GMT

Current revision posted to APIs by Manish bhargava on 5/8/2012 9:59:10 AM

Coming in June...

Lawyer Search

Manish bhargava — Tue, 08 May 2012 13:57:09 GMT

Current revision posted to APIs by Manish bhargava on 5/8/2012 9:57:09 AM

Coming in June...

Azure Data Market - Community Data

Marc Slovak — Mon, 26 Sep 2011 15:23:07 GMT

Current revision posted to APIs by Marc Slovak on 9/26/2011 11:23:07 AM

Azure Data Market - Community Data

Filed under: azure, community, blogs, blogpost, podcast, user generated content

We have created a reference site with downloadable code examples to illustrate how you can use the ODATA API to retrieve our data from SQL Azure and display it on your website. You can find a link to the site at

http://www.lexisnexisstore.com/datamarket

Blogposts and Podcasts from the LexisNexis Online Communities ( http://www.lexisnexis.com/community/portal/ ) are now available through the Microsoft Azure DataMarket ( https://datamarket.azure.com/ ). The dataset includes LexisNexis and user generated content for a rolling six month period. This information is available at no cost through Azure DataMarket. This data may be displayed on your website as long as all LexisNexis branding remains in place and you agree to the terms and conditions of the LexisNexis Developer License Agreement.

DATA SET

The data set consists of "blogposts" and "podcasts" originally posted in the LexisNexis Communities. The previous six months of postings are included in the data yielding approximately 2500 blogposts and 500 podcasts on a variety of current legal topics. The data is contained in a single table accessible through Azure DataMarket. The table data is as follows:

Data	Description	Notes
Id	Unique Identity
Title	Blog or Podcast Title
Link	Link to the content online
MediaLink	Link to podcast mp3 file
Extract	Summary of the item	First 150 characters of the item content
Content	Full content of the item	Entire content of the blogpost or podcast description
Author	Author name
AuthorEmail	Author email address
AuthorWeblink	Author site url	May be blank
DatePublished	Date the item was published	mm-dd-yyyy hh:mm:ss
ContentType	Item type	"blogpost" or "podcast"
CommunityName	Community Long Name	*** See below for listing
Keywords	Tags
LexisID	Permanent LexisID for the item	Lexis identifier
CommunityAbbreviation	Abbreviated Community Name	*** See below for listing

Data in RED can be queried.

ITEM TYPES
blogpost
podcast

COMMUNITY (LONG NAMES)
Corporate & Securities Law Community
Legal Business Community
Workers' Compensation Law Community Powered by Larson's
Real Estate Law Community
Estate Practice & Elder Law Community
Tax Law Community
International & Foreign Law Community
Immigration Law COmmunity
Patent Law Community
Copyright & Trademark Law Community
Litigation Resource Community
Environmental Law & Climate Change Community
Bankruptcy Law Community
Emerging Issues Law Community
Insurance Law Community
Legal Communities
Lexis Hub for New Attorneys
Labor & Employment Law Community

COMMUNITY_SHORTNAME (searchable)
corpsec
legalbusiness
workerscomp
realestate
elder
tax
international
immigration
patent
copyrighttrademark
litigationresources
environment
bankruptcy
emerging
insurance
legalcommunities
newattorneys
laboremployment

SAMPLE QUERIES

select * from consumer.dbo.gmes_community_content where charindex(‘blogpost’,item_type) > 0

select * from consumer.dbo.gmes_community_content where community_shortname = ‘patentlaw’

VISUALIZATIONS

The following is an example of a podcast post. A simple media listener has been inserted using the attachment address of the mp3 file.

The following is an example of a typical blog post

Azure Data Market - Community Data

Marc Slovak — Fri, 02 Sep 2011 17:01:05 GMT

Revision 14 posted to APIs by Marc Slovak on 9/2/2011 1:01:05 PM

Azure Data Market - Community Data

Filed under: azure, community, blogs, blogpost, podcast, user generated content

http://www.lexisnexisstore.com/datamarket

DATA SET

Data	Description	Notes
Id	Unique Identity
Title	Blog or Podcast Title
Link	Link to the content online
MediaLink	Link to podcast mp3 file
Extract	Summary of the item	First 150 characters of the item content
Content	Full content of the item	Entire content of the blogpost or podcast description
Author	Author name
AuthorEmail	Author email address
AuthorWeblink	Author site url	May be blank
DatePublished	Date the item was published	mm-dd-yyyy hh:mm:ss
ContentType	Item type	"blogpost" or "podcast"
CommunityName	Community Long Name	*** See below for listing
Keywords	Tags
LexisID	Permanent LexisID for the item	Lexis identifier
CommunityAbbreviation	Abbreviated Community Name	*** See below for listing

Data in RED can be queried.

ITEM TYPES
blogpost
podcast

COMMUNITY (LONG NAMES)
Corporate & Securities Law Community
Legal Business Community
Workers' Compensation Law Community Powered by Larson's
Real Estate Law Community
Estate Practice & Elder Law Community
Tax Law Community
International & Foreign Law Community
Patent Law Community
Copyright & Trademark Law Community
Litigation Resource Community
Environmental Law & Climate Change Community
Bankruptcy Law Community
Emerging Issues Law Community
Insurance Law Community
Legal Communities
Lexis Hub for New Attorneys
Labor & Employment Law Community

COMMUNITY_SHORTNAME (searchable)
corpsec
legalbusiness
workerscomp
realestate
elder
tax
international
patent
copyrighttrademark
litigationresources
environment
bankruptcy
emerging
insurance
legalcommunities
newattorneys
laboremployment

SAMPLE QUERIES

select * from consumer.dbo.gmes_community_content where charindex(‘blogpost’,item_type) > 0

select * from consumer.dbo.gmes_community_content where community_shortname = ‘patentlaw’

VISUALIZATIONS

The following is an example of a podcast post. A simple media listener has been inserted using the attachment address of the mp3 file.

The following is an example of a typical blog post

Azure Data Market - Community Data

Marc Slovak — Fri, 02 Sep 2011 17:00:22 GMT

Revision 13 posted to APIs by Marc Slovak on 9/2/2011 1:00:22 PM

Azure Data Market - Community Data

Filed under: azure, community, blogs, blogpost, podcast, user generated content

DATA SET

Data	Description	Notes
Id	Unique Identity
Title	Blog or Podcast Title
Link	Link to the content online
MediaLink	Link to podcast mp3 file
Extract	Summary of the item	First 150 characters of the item content
Content	Full content of the item	Entire content of the blogpost or podcast description
Author	Author name
AuthorEmail	Author email address
AuthorWeblink	Author site url	May be blank
DatePublished	Date the item was published	mm-dd-yyyy hh:mm:ss
ContentType	Item type	"blogpost" or "podcast"
CommunityName	Community Long Name	*** See below for listing
Keywords	Tags
LexisID	Permanent LexisID for the item	Lexis identifier
CommunityAbbreviation	Abbreviated Community Name	*** See below for listing

Data in RED can be queried.

ITEM TYPES
blogpost
podcast

COMMUNITY (LONG NAMES)
Corporate & Securities Law Community
Legal Business Community
Workers' Compensation Law Community Powered by Larson's
Real Estate Law Community
Estate Practice & Elder Law Community
Tax Law Community
International & Foreign Law Community
Patent Law Community
Copyright & Trademark Law Community
Litigation Resource Community
Environmental Law & Climate Change Community
Bankruptcy Law Community
Emerging Issues Law Community
Insurance Law Community
Legal Communities
Lexis Hub for New Attorneys
Labor & Employment Law Community

SAMPLE QUERIES

select * from consumer.dbo.gmes_community_content where charindex(‘blogpost’,item_type) > 0

select * from consumer.dbo.gmes_community_content where community_shortname = ‘patentlaw’

VISUALIZATIONS

The following is an example of a podcast post. A simple media listener has been inserted using the attachment address of the mp3 file.

The following is an example of a typical blog post

Azure Data Market - Community Data

Marc Slovak — Tue, 30 Aug 2011 15:21:09 GMT

Revision 12 posted to APIs by Marc Slovak on 8/30/2011 11:21:09 AM

Azure Data Market - Community Data

Filed under: azure, community, blogs, blogpost, podcast, user generated content

DATA SET

Data	Description	Notes
Id	Unique Identity
Title	Blog or Podcast Title
Link	Link to the content online
MediaLink	Link to podcast mp3 file
Extract	Summary of the item	First 150 characters of the item content
Content	Full content of the item	Entire content of the blogpost or podcast description
Author	Author name
AuthorEmail	Author email address
AuthorWeblink	Author site url	May be blank
DatePublished	Date the item was published	mm-dd-yyyy hh:mm:ss
ContentType	Item type	"blogpost" or "podcast"
CommunityName	Community Long Name	*** See below for listing
Keywords	Tags
LexisID	Permanent LexisID for the item	Lexis identifier
CommunityAbbreviation	Abbreviated Community Name	*** See below for listing

Data in RED can be queried.

ITEM TYPES
blogpost
podcast

COMMUNITY (LONG NAMES)
Corporate & Securities Law Community
Legal Business Community
Torts & Personal Injury Law Community
Workers' Compensation Law Community Powered by Larson's
Real Estate Law Community
Estate Practice & Elder Law Community
Tax Law Community
International & Foreign Law Community
Patent Law Community
Copyright & Trademark Law Community
Litigation Resource Community
Environmental Law & Climate Change Community
Bankruptcy Law Community
Emerging Issues Law Community
Insurance Law Community
Legal Communities
Lexis Hub for New Attorneys
Labor & Employment Law Community

COMMUNITY_SHORTNAME (searchable)
corpsec
legalbusiness
tortspersonalinjury
workerscomp
realestate
elder
tax
international
patent
copyrighttrademark
litigationresources
environment
bankruptcy
emerging
insurance
legalcommunities
newattorneys
laboremployment

SAMPLE QUERIES

select * from consumer.dbo.gmes_community_content where charindex(‘blogpost’,item_type) > 0

select * from consumer.dbo.gmes_community_content where community_shortname = ‘patentlaw’

VISUALIZATIONS

The following is an example of a podcast post. A simple media listener has been inserted using the attachment address of the mp3 file.

The following is an example of a typical blog post

Azure Data Market - Community Data

Marc Slovak — Tue, 12 Jul 2011 15:58:00 GMT

Revision 11 posted to APIs by Marc Slovak on 7/12/2011 11:58:00 AM

Azure Data Market - Community Data

Filed under: azure, community, blogs, blogpost, podcast, user generated content

DATA SET

Data	Description	Notes
Id	Unique Identity
Title	Blog or Podcast Title
Link	Link to the content online
MediaLink	Link to podcast mp3 file
Extract	Summary of the item	First 150 characters of the item content
Content	Full content of the item	Entire content of the blogpost or podcast description
Author	Author name
AuthorEmail	Author email address
AuthorWeblink	Author site url	May be blank
DatePublished	Date the item was published	mm-dd-yyyy hh:mm:ss
ContentType	Item type	"blogpost" or "podcast"
CommunityName	Community Long Name	*** See below for listing
Keywords	Tags
LexisID	Permanent LexisID for the item	Lexis identifier
CommunityAbbreviation	Abbreviated Community Name	*** See below for listing

Data in RED can be queried.

ITEM TYPES
blogpost
podcast

COMMUNITY (LONG NAMES)
Corporate & Securities Law Community
Legal Business Community
Torts & Personal Injury Law Community
Workers' Compensation Law Community Powered by Larson's
Real Estate Law Community
Estate Practice & Elder Law Community
Tax Law Community
International & Foreign Law Community
Patent Law Community
Copyright & Trademark Law Community
Litigation Resource Community
Environmental Law & Climate Change Community
UCC, Commercial Contracts & Business Law Community
Bankruptcy Law Community
Emerging Issues Law Community
Insurance Law Community
Legal Communities
Lexis Hub for New Attorneys
Labor & Employment Law Community

COMMUNITY_SHORTNAME (searchable)
corpsec
legalbusiness
tortspersonalinjury
workerscomp
realestate
elder
tax
international
patent
copyrighttrademark
litigationresources
environment
contracts
bankruptcy
emerging
insurance
legalcommunities
newattorneys
laboremployment

SAMPLE QUERIES

select * from consumer.dbo.gmes_community_content where charindex(‘blogpost’,item_type) > 0

select * from consumer.dbo.gmes_community_content where community_shortname = ‘patentlaw’

VISUALIZATIONS

The following is an example of a podcast post. A simple media listener has been inserted using the attachment address of the mp3 file.

The following is an example of a typical blog post

Azure Data Market - Community Data

Marc Slovak — Thu, 07 Jul 2011 01:47:21 GMT

Revision 10 posted to APIs by Marc Slovak on 7/6/2011 9:47:21 PM

Azure Data Market - Community Data

Filed under: azure, community, blogs, blogpost, podcast, user generated content

DATA SET

Data	Description	Notes
ID
Id	Unique Identity
TITLE
Title	Blog or Podcast Title
LINK
Link	Link to the content online
MEDIA_LINK
MediaLink	Link to podcast mp3 file
CONTENT_EXTRACT
Extract	Summary of the item	First 150 characters of the item content
CONTENT_FULL
Content	Full content of the item	Entire content of the blogpost or podcast description
AUTHOR
Author	Author name
AUTHOR_EMAIL
AuthorEmail	Author email address
AUTHOR_URL
AuthorWeblink	Author site url	May be blank
PUBLISH_DATE
DatePublished	Date the item was published	mm-dd-yyyy hh:mm:ss
ITEM TYPE
ContentType	Item type	"blogpost" or "podcast"
COMMUNITY
CommunityName	Community Long Name	*** See below for listing
KEYWORDS
Keywords	Tags
LEXIS_ID
LexisID	Permanent LexisID for the item	Lexis identifier
COMMUNITY_SHORTNAME
CommunityAbbreviation	Abbreviated Community Name	*** See below for listing

Data in RED can be queried.

ITEM TYPES
blogpost
podcast

COMMUNITY (LONG NAMES)
Corporate & Securities Law Community
Legal Business Community
Torts & Personal Injury Law Community
Workers' Compensation Law Community Powered by Larson's
Real Estate Law Community
Estate Practice & Elder Law Community
Tax Law Community
International & Foreign Law Community
Patent Law Community
Copyright & Trademark Law Community
Litigation Resource Community
Environmental Law & Climate Change Community
UCC, Commercial Contracts & Business Law Community
Bankruptcy Law Community
Emerging Issues Law Community
Insurance Law Community
Legal Communities
Lexis Hub for New Attorneys
Labor & Employment Law Community

COMMUNITY_SHORTNAME (searchable)
corpsec
legalbusiness
tortspersonalinjury
workerscomp
realestate
elder
tax
international
patent
copyrighttrademark
litigationresources
environment
contracts
bankruptcy
emerging
insurance
legalcommunities
newattorneys
laboremployment

SAMPLE QUERIES

select * from consumer.dbo.gmes_community_content where charindex(‘blogpost’,item_type) > 0

select * from consumer.dbo.gmes_community_content where community_shortname = ‘patentlaw’

VISUALIZATIONS

The following is an example of a podcast post. A simple media listener has been inserted using the attachment address of the mp3 file.

The following is an example of a typical blog post

Azure Data Market - Community Data

Marc Slovak — Wed, 06 Jul 2011 16:35:23 GMT

Revision 9 posted to APIs by Marc Slovak on 7/6/2011 12:35:23 PM

Azure Data Market - Community Data

Filed under: azure, community, blogs, blogpost, podcast, user generated content

DATA SET

Data	Description	Notes
ID	Unique Identity
TITLE	Blog or Podcast Title
LINK	Link to the content online
MEDIA_LINK	Link to podcast mp3 file
CONTENT_EXTRACT	Summary of the item	First 150 characters of the item content
CONTENT_FULL	Full content of the item	Entire content of the blogpost or podcast description
AUTHOR	Author name
AUTHOR_EMAIL	Author email address
AUTHOR_URL	Author site url	May be blank
PUBLISH_DATE	Date the item was published	mm-dd-yyyy hh:mm:ss
ITEM TYPE	Item type	"blogpost" or "podcast"
COMMUNITY	Community Long Name	*** See below for listing
KEYWORDS	Tags
LEXIS_ID	Permanent LexisID for the item	Lexis identifier
COMMUNITY_SHORTNAME	Abbreviated Community Name	*** See below for listing

Data in RED can be queried.

ITEM TYPES
blogpost
podcast

COMMUNITY (LONG NAMES)
Corporate & Securities Law Community
Legal Business Community
Torts & Personal Injury Law Community
Workers' Compensation Law Community Powered by Larson's
Real Estate Law Community
Estate Practice & Elder Law Community
Tax Law Community
International & Foreign Law Community
Patent Law Community
Copyright & Trademark Law Community
Litigation Resource Community
Environmental Law & Climate Change Community
UCC, Commercial Contracts & Business Law Community
Bankruptcy Law Community
Emerging Issues Law Community
Insurance Law Community
Legal Communities
Lexis Hub for New Attorneys
Labor & Employment Law Community

COMMUNITY_SHORTNAME (searchable)
corpsec
legalbusiness
tortspersonalinjury
workerscomp
realestate
elder
tax
international
patent
copyrighttrademark
litigationresources
environment
contracts
bankruptcy
emerging
insurance
legalcommunities
newattorneys
laboremployment

SAMPLE QUERIES

select * from consumer.dbo.gmes_community_content where charindex(‘blogpost’,item_type) > 0

select * from consumer.dbo.gmes_community_content where community_shortname = ‘patentlaw’

VISUALIZATIONS

The following is an example of a podcast post. A simple media listener has been inserted using the attachment address of the mp3 file.

The following is an example of a typical blog post

Azure Data Market - Community Data

Marc Slovak — Wed, 06 Jul 2011 16:34:37 GMT

Revision 8 posted to APIs by Marc Slovak on 7/6/2011 12:34:37 PM

Azure Data Market - Community Data

Filed under: azure, community, blogs, blogpost, podcast, user generated content

DATA SET

Data	Description	Notes
ID	Unique Identity
TITLE	Blog or Podcast Title
LINK	Link to the content online
MEDIA_LINK	Link to podcast mp3 file
CONTENT_EXTRACT	Summary of the item	First 150 characters of the item content
CONTENT_FULL	Full content of the item	Entire content of the blogpost or podcast description
AUTHOR	Author name
AUTHOR_EMAIL	Author email address
AUTHOR_URL	Author site url	May be blank
PUBLISH_DATE	Date the item was published	mm-dd-yyyy hh:mm:ss
ITEM TYPE	Item type	"blogpost" or "podcast"
COMMUNITY	Community Long Name	*** See below for listing
KEYWORDS	Tags
LEXIS_ID	Permanent LexisID for the item	Lexis identifier
COMMUNITY_SHORTNAME	Abbreviated Community Name	*** See below for listing

Data in RED can be queried.

ITEM TYPES
blogpost
podcast

COMMUNITY (LONG NAMES)
Corporate & Securities Law Community
Legal Business Community
Torts & Personal Injury Law Community
Workers' Compensation Law Community Powered by Larson's
Real Estate Law Community
Estate Practice & Elder Law Community
Tax Law Community
International & Foreign Law Community
Patent Law Community
Copyright & Trademark Law Community
Litigation Resource Community
Environmental Law & Climate Change Community
UCC, Commercial Contracts & Business Law Community
Bankruptcy Law Community
Emerging Issues Law Community
Insurance Law Community
Legal Communities
Lexis Hub for New Attorneys
Labor & Employment Law Community

COMMUNITY_SHORTNAME (searchable)
corpsec
legalbusiness
tortspersonalinjury
workerscomp
realestate
elder
tax
international
patent
copyrighttrademark
litigationresources
environment
contracts
bankruptcy
emerging
insurance
legalcommunities
newattorneys
laboremployment

SAMPLE QUERIES

select * from consumer.dbo.gmes_community_content where charindex(‘blogpost’,item_type) > 0

select * from consumer.dbo.gmes_community_content where community_shortname = ‘patentlaw’

VISUALIZATIONS

The following is an example of a podcast post. A simple media listener has been inserted using the attachment address of the mp3 file.

The following is an example of a typical blog post

Azure Data Market - Community Data

Marc Slovak — Thu, 09 Jun 2011 13:21:09 GMT

Revision 7 posted to APIs by Marc Slovak on 6/9/2011 9:21:09 AM

Azure Data Market - Community Data

Filed under: azure, community, blogs, blogpost, podcast, user generated content

DATA SET

Data	Description	Notes
ID	Unique Identity
TITLE	Blog or Podcast Title
LINK	Link to the content online
MEDIA_LINK	Link to podcast mp3 file
CONTENT_EXTRACT	Summary of the item	First 150 characters of the item content
CONTENT_FULL	Full content of the item	Entire content of the blogpost or podcast description
AUTHOR	Author name
AUTHOR_EMAIL	Author email address
AUTHOR_URL	Author site url	May be blank
PUBLISH_DATE	Date the item was published	mm-dd-yyyy hh:mm:ss
ITEM TYPE	Item type	"blogpost" or "podcast"
COMMUNITY	Community Long Name	*** See below for listing
KEYWORDS	Tags
LEXIS_ID	Permanent LexisID for the item	Lexis identifier
COMMUNITY_SHORTNAME	Abbreviated Community Name	*** See below for listing

Data in RED can be queried.

ITEM TYPES
blogpost
podcast

COMMUNITY (LONG NAMES)
Corporate & Securities Law Community
Legal Business Community
Torts & Personal Injury Law Community
Workers' Compensation Law Community Powered by Larson's
Real Estate Law Community
Estate Practice & Elder Law Community
Tax Law Community
International & Foreign Law Community
Patent Law Community
Copyright & Trademark Law Community
Litigation Resource Community
Environmental Law & Climate Change Community
UCC, Commercial Contracts & Business Law Community
Bankruptcy Law Community
Emerging Issues Law Community
Insurance Law Community
Legal Communities
Lexis Hub for New Attorneys

COMMUNITY_SHORTNAME (searchable)
corpsec
legalbusiness
tortspersonalinjury
workerscomp
realestate
elder
tax
international
patent
copyrighttrademark
litigationresources
environment
contracts
bankruptcy
emerging
insurance
legalcommunities
newattorneys

SAMPLE QUERIES

select * from consumer.dbo.gmes_community_content where charindex(‘blogpost’,item_type) > 0

select * from consumer.dbo.gmes_community_content where community_shortname = ‘patentlaw’

VISUALIZATIONS

The following is an example of a podcast post. A simple media listener has been inserted using the attachment address of the mp3 file.

The following is an example of a typical blog post

Azure Data Market - Community Data

Marc Slovak — Thu, 09 Jun 2011 13:18:40 GMT

Revision 6 posted to APIs by Marc Slovak on 6/9/2011 9:18:40 AM

Azure Data Market - Community Data

Filed under: azure, community, blogs, blogpost, podcast, user generated content

DATA SET

Data	Description	Notes
ID	Unique Identity
TITLE	Blog or Podcast Title
LINK	Link to the content online
MEDIA_LINK	Link to podcast mp3 file
CONTENT_EXTRACT	Summary of the item	First 150 characters of the item content
CONTENT_FULL	Full content of the item	Entire content of the blogpost or podcast description
AUTHOR	Author name
AUTHOR_EMAIL	Author email address
AUTHOR_URL	Author site url	May be blank
PUBLISH_DATE	Date the item was published	mm-dd-yyyy hh:mm:ss
ITEM TYPE	Item type	"blogpost" or "podcast"
COMMUNITY	Community Long Name	*** See below for listing
KEYWORDS	Tags
LEXIS_ID	Permanent LexisID for the item	Lexis identifier
COMMUNITY_SHORTNAME	Abbreviated Community Name	*** See below for listing

Data in RED can be queried.

ITEM TYPES
blogpost
podcast

COMMUNITY (LONG NAMES)
Corporate & Securities Law Community
Legal Business Community
Torts & Personal Injury Law Community
Workers' Compensation Law Community Powered by Larson's
Real Estate Law Community
Estate Practice & Elder Law Community
Tax Law Community
International & Foreign Law Community
Patent Law Community
Copyright & Trademark Law Community
Litigation Resource Community
Environmental Law & Climate Change Community
UCC, Commercial Contracts & Business Law Community
Bankruptcy Law Community
Emerging Issues Law Community
Insurance Law Community
Legal Communities
Lexis Hub for New Attorneys

COMMUNITY_SHORTNAME (searchable)
corpsec
legalbusiness
tortspersonalinjury
workerscomp
realestate
elder
tax
international
patent
copyrighttrademark
litigationresources
environment
contracts
bankruptcy
emerging
insurance
legalcommunities
newattorneys

SAMPLE QUERIES

select * from consumer.dbo.gmes_community_content where charindex(‘blogpost’,item_type) > 0

select * from consumer.dbo.gmes_community_content where community_shortname = ‘patentlaw’

VISUALIZATIONS

The following is an example of a podcast post. A simple media listener has been inserted using the attachment address of the mp3 file.

The following is an example of a typical blog post

Azure Data Market - Community Data

Marc Slovak — Wed, 04 May 2011 14:47:33 GMT

Revision 5 posted to APIs by Marc Slovak on 5/4/2011 10:47:33 AM

Azure Data Market - Community Data

Filed under: azure, community, blogs, blogpost, podcast, user generated content

DATA SET

Data	Description	Notes
ID	Unique Identity
TITLE	Blog or Podcast Title
LINK	Link to the content online
MEDIA_LINK	Link to podcast mp3 file
CONTENT_EXTRACT	Summary of the item	First 150 characters of the item content
CONTENT_FULL	Full content of the item	Entire content of the blogpost or podcast description
AUTHOR	Author name
AUTHOR_EMAIL	Author email address
AUTHOR_URL	Author site url	May be blank
PUBLISH_DATE	Date the item was published	mm-dd-yyyy hh:mm:ss
ITEM TYPE	Item type	"blogpost" or "podcast"
COMMUNITY	Community Long Name	*** See below for listing
KEYWORDS	Tags
LEXIS_ID	Permanent LexisID for the item	Lexis identifier
COMMUNITY_SHORTNAME	Abbreviated Community Name	*** See below for listing

Data in RED can be queried.

ITEM TYPES
blogpost
podcast

COMMUNITY (LONG NAMES)
Corporate & Securities Law Community
Legal Business Community
Torts & Personal Injury Law Community
Workers' Compensation Law Community Powered by Larson's
Real Estate Law Community
Estate Practice & Elder Law Community
Tax Law Community
International & Foreign Law Community
Patent Law Community
Copyright & Trademark Law Community
Litigation Resource Community
Environmental Law & Climate Change Community
UCC, Commercial Contracts & Business Law Community
Bankruptcy Law Community
Emerging Issues Law Community
Insurance Law Community
Legal Communities
Lexis Hub for New Attorneys

COMMUNITY_SHORTNAME (searchable)
corpsec
legalbusiness
tortspersonalinjury
workerscomp
realestate
elder
tax
international
patent
copyrighttrademark
litigationresources
environment
contracts
bankruptcy
emerging
insurance
legalcommunities
newattorneys

SAMPLE QUERIES

select * from consumer.dbo.gmes_community_content where charindex(‘blogpost’,item_type) > 0

select * from consumer.dbo.gmes_community_content where community_shortname = ‘patentlaw’

VISUALIZATIONS

The following is an example of a podcast post. A simple media listener has been inserted using the attachment address of the mp3 file.

The following is an example of a typical blog post

Azure Data Market - Community Data

Marc Slovak — Tue, 03 May 2011 18:06:48 GMT

Revision 4 posted to APIs by Marc Slovak on 5/3/2011 2:06:48 PM

Azure Data Market - Community Data

Filed under: azure, community, blogs, blogpost, podcast, user generated content

DATA SET

Data	Description	Notes
ID	Unique Identity
TITLE	Blog or Podcast Title
LINK	Link to the content online
MEDIA_LINK	Link to podcast mp3 file
CONTENT_EXTRACT	Summary of the item	First 150 characters of the item content
CONTENT_FULL	Full content of the item	Entire content of the blogpost or podcast description
AUTHOR	Author name
AUTHOR_EMAIL	Author email address
AUTHOR_URL	Author site url	May be blank
PUBLISH_DATE	Date the item was published	mm-dd-yyyy hh:mm:ss
ITEM TYPE	Item type	"blogpost" or "podcast"
COMMUNITY	Community Long Name	*** See below for listing
KEYWORDS	Tags
LEXIS_ID	Permanent LexisID for the item	Lexis identifier
COMMUNITY_SHORTNAME	Abbreviated Community Name	*** See below for listing

Data in RED can be queried.

ITEM TYPES
blogpost
podcast

COMMUNITY (LONG NAMES)
Corporate & Securities Law Community
Legal Business Community
Torts & Personal Injury Law Community
Workers' Compensation Law Community Powered by Larson's
Real Estate Law Community
Estate Practice & Elder Law Community
Tax Law Community
International & Foreign Law Community
Patent Law Community
Copyright & Trademark Law Community
Litigation Resource Community
Environmental Law & Climate Change Community
UCC, Commercial Contracts & Business Law Community
Bankruptcy Law Community
Emerging Issues Law Community
Insurance Law Community
Legal Communities
Lexis Hub for New Attorneys

COMMUNITY_SHORTNAME (searchable)
corpsec
legalbusiness
tortspersonalinjury
workerscomp
realestate
elder
tax
international
patent
copyrighttrademark
litigationresources
environment
contracts
bankruptcy
emerging
insurance
legalcommunities
newattorneys

SAMPLE QUERIES

select * from consumer.dbo.gmes_community_content where charindex(‘blogpost’,item_type) > 0

select * from consumer.dbo.gmes_community_content where community_shortname = ‘patentlaw’